Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Remove item from Tools menu
Hi everyone Happy New Year
At some point in the distant past I put in place a Worksheet macro to run a Drop Down list. Some where along the line I also added a command button to the Tools menu, the purpose of which is now unclear as the Drop Down List Box is permanently displayed. Macro places my selection in the active cell and resets the Drop Down window to blank. My problem is that what ever I do I can not permanently delete/remove this button from the Tools menu. It is removed from the menu when I go ToolsCustomizeToolsRight Click on buttonDelete but when ever I open the Workbook again it has returned. Not sure if relevant but if I create a new Workbook while in the one with the 'rouge' button the problem is recreated. Interestingly if I copy even a single cell from 'faulty' Workbook to a 'clean' one the 'rouge' button is inserted on the Tools menu of the new 'clean' Wrkbook. Again unsure if relevant but this particular Workbook was originally created in Excel 95 where as I am now using 2003. Only place I can find/see any reference to the 'Button' is when I open the Workbook with Notepad. Does any one have any suggestions? Regards Arran |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
No Data Analysis item in Excel Tools menu. Now what? | Excel Worksheet Functions | |||
remove name of addin in Tools menu: "Document Project" | Excel Discussion (Misc queries) | |||
Adding menu item to Tools | Excel Programming | |||
Menu items added with menu item editor in older versions | Excel Discussion (Misc queries) | |||
How to remove an Excel Main Menu item inserted by .xla file | Excel Discussion (Misc queries) |