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

macros

ResolvedVersion 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:

Select blank cells automatically

Get Excel to find any blank (empty) cells in a region for you by:

1. Selecting the appropriate region from your spreadsheet.

2. On the menu bar, go to Edit - Go to.

3. Click the 'Special' button, then select Blanks and click OK.

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.1 secs.