You can avoid lots of problems by making the changes to the menu when your
workbook opens and then fixing the menu when the workbook closes.

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://groups.google.co.uk/groups?th...5B41%40msn.com


Sean wrote:

I added a menu item to my document to make it easier to run my code. Now
every document I open in Excel has this menu in it (although the macro
doesn't run) and if I send my document to someone else the menu doesn't
appear. I added the menu using the functionality in View -- Toolbars --
Customize... and linked it to a macro. I believe this is a simple fix.. what
am I doing wrong here.

--

Dave Peterson