Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macros for template | New Users to Excel | |||
Template with macros | Excel Discussion (Misc queries) | |||
Where do I find a template for a high school template? | Excel Discussion (Misc queries) | |||
Macros in Template | Excel Programming | |||
Macros in a template | Excel Programming |