Hi, I have a workbook that contains multiple macros that work fine on that file.
I want to use those macros on another new file.
I have created a personal.xlsb, (in XLStart) it loads up every time, however when I open the second workbook and activate the macro it runs on the personal.xlsb file, not the new one - phew.
Have I missed some vba code in the orginal 'master personal.xlsb file or something else please ?
Just stuck - help gratefully received.
I'm using excel 2007 on a standalone pc
Thanks - Peter
PS THe reason is to separate the macro's from a file that is eventually sent elsewhere - so trying to protect my macro construction.
Bookmarks