How to copy a Macro to another PC

F

FL

How can I find and copy an Excel macro to another PC. As I recall the one I
created also created a file called Personal.xls that automatically opens up.
Not sure if this is the only file that needs to be copied? Also, where does
it get copied to? What location? Same as original PC?
 
B

Bernard Liengme

Personal.xls is automatically opened (if it exists) but is hidden; use
Widows | Unhide to see if you have one. Generally it is kept in the XLSTART
folder; find it with a search.

However, some people have Excel open other files automatically; Use Tools |
Options and look on the General tab to see if your Excel is set up this way.

Use Tools| Macros | VBA editor to check which file has the macro

Copy the file to the other PC and locate in the same folder.
 
Top