Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Urgent please - Macro stored in template cannot be found
I have a template called Event Planner v0.3. It has a macro called
InsertSpeaker, assigned to a custom toolbar. If I create a new spreadsheet based on the template, a message says that "The macro C:\Program Files\CommonFiles\System\MSMAPI\1033\Event Planner v0.31'InsertSpeaker' cannot be found. If you go to Macros, and select Macros in, it shows macros in Event Planner v0.31. Why, when the template is called v0.3? In Visual Basic Project Explorer, I've tried storing the macro in a Module, specified "this workbook" and all sorts, without success. How can I tell the template to look for the macro in the Event Planner v0.3 regardless of where it is actually located? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Urgent please - Macro stored in template cannot be found
have you tried using a command button and storing the code within the
worksheet and command button ? If you are using forms buttons (Forms button - Assign Macro ect) it will not copy to a new sheet, where a command button code will. "Christine" wrote in message ... I have a template called Event Planner v0.3. It has a macro called InsertSpeaker, assigned to a custom toolbar. If I create a new spreadsheet based on the template, a message says that "The macro C:\Program Files\CommonFiles\System\MSMAPI\1033\Event Planner v0.31'InsertSpeaker' cannot be found. If you go to Macros, and select Macros in, it shows macros in Event Planner v0.31. Why, when the template is called v0.3? In Visual Basic Project Explorer, I've tried storing the macro in a Module, specified "this workbook" and all sorts, without success. How can I tell the template to look for the macro in the Event Planner v0.3 regardless of where it is actually located? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Urgent please - Macro stored in template cannot be found
Thanks for responding so quickly Corey.
I currently call the macro via a customised tool bar. I did try the command button and that seems to work. However, I would really like to stick with the tool bar. Any assistance will be appreciated! "Corey" wrote: have you tried using a command button and storing the code within the worksheet and command button ? If you are using forms buttons (Forms button - Assign Macro ect) it will not copy to a new sheet, where a command button code will. "Christine" wrote in message ... I have a template called Event Planner v0.3. It has a macro called InsertSpeaker, assigned to a custom toolbar. If I create a new spreadsheet based on the template, a message says that "The macro C:\Program Files\CommonFiles\System\MSMAPI\1033\Event Planner v0.31'InsertSpeaker' cannot be found. If you go to Macros, and select Macros in, it shows macros in Event Planner v0.31. Why, when the template is called v0.3? In Visual Basic Project Explorer, I've tried storing the macro in a Module, specified "this workbook" and all sorts, without success. How can I tell the template to look for the macro in the Event Planner v0.3 regardless of where it is actually located? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
where I found a free template fro value stream mapping | Excel Discussion (Misc queries) | |||
Call macro stored in Excel workbook from Outlook's macro | Excel Programming | |||
Formula Not Found - Urgent! | Excel Programming | |||
URGENT -- search in string for a value in another column, if found, return value from next column | Excel Programming | |||
Where can similar macro template / sample be found? | Excel Programming |