Your life will become much simpler if you include code to create the toolbar
when the workbook is opened and include code to destroy the toolbar when the
workbook is closed.
For additions to the worksheet menu bar, I really like the way John Walkenbach
does it in his menumaker workbook:
http://j-walk.com/ss/excel/tips/tip53.htm
Here's how I do it when I want a toolbar:
http://www.contextures.com/xlToolbar02.html
(from Debra Dalgleish's site)
Claus Højlund wrote:
I have created my own menu and connected a macro to my own ikon. I have then
renamed the spreadsheet. When opened on another PC my ikon does not work. It
calls the right macro but wants to open the spreadsheet with the old name.
How do I fix this?
--
Dave Peterson