macros

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Macros

Macros

resolvedResolved · Low Priority · Version 2007

Tom has attended:
Excel Advanced course

Macros

Is it possible to transfer macros from one workbook to another, if they have not been saved in the personal macro workbook?

RE: Macros

Hi Tom
Thanks for the post - sorry for not getting back to you before

There is a way of using a macro from another workbook, what you will need to do is open the workbook that the macro is in - then go into the macro by macro view or, ALT F8 then click edit

Then copy the data from there to the other file in the same place

Hope this helps you

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


 

Excel tip:

Manually wrapping text

To manually wrap text, use the shortcut key Alt+Enter.

To cancel manual text wrapping, simply delete the new line.

View all Excel hints and tips


Server loaded in 0.08 secs.