Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

macros

ResolvedVersion 2007

Ashley has attended:
Excel Advanced course

Macros

How do I copy macros into a new workbook?

RE: Macros

Hi Ashley

Thanks for your post - sorry for the late reply

there is 2 easy ways to get marco's in a new workbook 1. open the create the macro in the file you are in and when you start creating this choose to store it in your personal macro work book - this will enable you to use this in any workbook, or 2. go into the macro you want to copy, and when you are in the macro editer you can copy and paste the macro into VBA for the new workbook

Hope this helps

If this posting has helped in answering your query then I would request you to mark the posting as Resolved. If, however, it hasn

Wed 14 Jan 2009: Automatically marked as resolved.

Excel tip:

Adding up rows or columns without seeing formulas

Highlight a column or row and click the Autosum button. This gives you your answer without showing the formula.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.16 secs.