Change the path to your Personal.xls.

ToolsCustomize. Click on the button and "Assign Macro"

Delete all but Personal.xls!PrtPageNums


Gord Dibben MS Excel MVP

On Tue, 24 Jul 2007 10:38:04 -0700, JMay wrote:

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