can't find macros in template
 

hi

I have been trying to create a template for excel that will be th
standard and only template used in a system we are building. I hav
created the template and saved it but each time I click on the custo
buttons on a new menu bar I get an error messgae saying it cannot fin
the macro. I saved the template as EDMS.xlt. Even when I double clic
it from Windows Explorer and try clicking the custom buttons, the
don't work. I have created templates in word and powerpoint succesfull
but Excel is proving to be elusive.

Does anyone have any ideas

--
Message posted from http://www.ExcelForum.com

can't find macros in template
 

If this is a real template, then when you open it (it must be opend to run
the code), it probaby renames itself. this might be part of the problem.
Perhaps you should create your buttons with code in the template.

you can check what the assignment is for the buttons:

sMacro = application.CommandBars("Custom 1").Controls(1).OnAction
msgbox sMacro

--
Regards,
Tom Ogilvy



"richperfect " wrote in message
...
hi

I have been trying to create a template for excel that will be the
standard and only template used in a system we are building. I have
created the template and saved it but each time I click on the custom
buttons on a new menu bar I get an error messgae saying it cannot find
the macro. I saved the template as EDMS.xlt. Even when I double click
it from Windows Explorer and try clicking the custom buttons, they
don't work. I have created templates in word and powerpoint succesfully
but Excel is proving to be elusive.

Does anyone have any ideas?


---
Message posted from http://www.ExcelForum.com/