Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I've created a Excel template with a number of macros to
run functions in this system. I've created a custom toolbar to run a number of these macros. The problem I've encountered is that the toolbar will become attached to a workbook saved from this template and when the template is opened next, the toolbar buttons cause the old worksheet to open and the macros running from the toolbar are in the old book and not the new one. I've tried "attaching" the toolbar; opening and closing the toolbar when the workbooks open and close; and deleting the toolbar every time a workbook closes. None of these things have solved the problem. Does anyone have a fuller understanding of how to make a custom toolbar run properly with templates and workbooks created from this template? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Custom toolbar for template - macros not working | Excel Discussion (Misc queries) | |||
Source Excel Template Pops Up when using a custom toolbar | Excel Discussion (Misc queries) | |||
Custom toolbar and macros | Excel Discussion (Misc queries) | |||
Custom Toolbar Macros | Excel Programming | |||
Attaching Macros to Custom Buttons | Excel Programming |