View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Christine Christine is offline
external usenet poster
 
Posts: 147
Default 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?