Macros/toolbar won't stay put
Posted by Lori DeBlois on December 04, 2001 6:30 AM
I have a custom toolbar that calls various macros pertaining to that workbook. I saved the workbook as a template. Each week, I start a new workbook from the template. My problem is this: When I create a new workbook from the template, the toolbar works fine. The next week when I create another new workbook (from the template) and go to use the toolbar, it first opens up the last book I created before running the macro. Can anyone help me with this?
Posted by Jerid on December 04, 2001 10:37 AM
It's because the toolbar is pointing to the Macros in the template. You need to reassign the ToolBar buttons after creating the new workbook. Either that or use Visual Basic to create the tool bar when each workbook is opened, instead of manually creating it in the template.
Jerid
Posted by Jerid on December 07, 2001 2:12 PM
Example of option #2
