Menu linked to macro showing up in all documents
 

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.

Menu linked to macro showing up in all documents
 

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