can't find macros in template

[richperfect]

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

 

[Tom Ogilvy]

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