Macros across workbooks ?

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.

I think your best bet is to turn your file into an Add-In.
Do a save-as and use the file extension .xlam
Next go to Files > Options > Add-ins > Go (bottom of dialog) > Make sure your add-in has a Check mark next to it.
Now every time you load excel your macros will be available for your use in every workbook.

Give this a shot, let me know how it works for you.