Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can you replicate macros for buttons on the Standard toolbar? | Excel Discussion (Misc queries) | |||
Assigning Macros to Buttons | Excel Discussion (Misc queries) | |||
assigning macro to toolbar button | Excel Worksheet Functions | |||
Assigning Macros to Buttons in Excel | Excel Worksheet Functions | |||
assigning macros to buttons or autoshapes | Excel Worksheet Functions |