Toolbar references to macros
Posted by Pete on January 14, 2002 6:16 AM
I have a spreadsheet that contains macros that are activated by buttons on a customised toolbar. I have attached the toolbar to the spreadsheet.
When the spreadsheet is copied and given a new name the buttons on the toolbar still point at the macros on the old spreadsheet. I would like to share the spreadsheet with others in my team and copies will be made.
The only way around this that I have found so far is to create another spreadsheet that only holds the macros and to make the buttons on the toolbar point to this new spreadsheet. However, this means that the macros spreadsheet is always running when the main spreadsheet is running.
Does anyone know of a sweeter way of dealing with this?