Assigning Macros to Toolbar buttons
 

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

Assigning Macros to Toolbar buttons
 

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