I've taken on a partner in my business, and I will need to copy some macros that I have in my PERSONAL.xls to the PERSONAL.xls on her computer.
I just want to copy the macros, not the entire PERSONAL.xls, because she has set Excel defaults different from mine.
I'll be grately deepful for your assistance.
In the VBE,
Click on the Personal.xlsb modules,
Select the desired macro,
Right click, select Export...
Save somewhere, thumbdrive ??, network drive ??
on the other computer, select Import file
Note that the file will have a .BAS extension
Ben Van Johnson
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks