Assigning Macros to Toolbar buttons

[Guest]

I'm working away from my office for a time - but on the PC I'm working on I
wanted to set up my Macros that I have on my home PC. I use the Personal.xls
which is in my XLSTART Folder. I copied the file into the New PC XLSTART
folder
and I'm able to run the Macros BUT ONLY from the Tools, Macros <<Select>> Run.

Although I set up an Icon for several of my macros - when I click the
toolbar Icon
I get the message:

The Macro "C:\Documents and Settings\JMay\Personal.xls'!PrtPageNums' cannot
be found.

What's going wrong here? I do an ALT-F11 and Personal.xls is loaded << that
of course is why I'm able to run the Macros from Tools, Macros..

What need Fixing? for my icons to FIND my <<currently loaded>>
Macros?

Thanks in advance;

Jim May

 

[Gord Dibben]

Change the path to your Personal.xls.

Tools>Customize. Click on the button and "Assign Macro"

Delete all but Personal.xls!PrtPageNums


Gord Dibben MS Excel MVP