Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Showing tabs at bottom of documents | Excel Discussion (Misc queries) | |||
Excel 03 Macro w/Menu not showing in 07 | Excel Discussion (Misc queries) | |||
Cells blanks in linked documents | Excel Discussion (Misc queries) | |||
OFFSET command and linked documents | Excel Worksheet Functions | |||
Approach Linked documents via INDIRECT | Links and Linking in Excel |