Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Deleting custom Commands from File Menu are nor saved next time w.
I have a Excel Document that contain many macros and it was protected.
I unprotected the doucment and deleted all macros but when I tried to delete a Custom command from FILE MENU under customize/rearrange commands, I would not see the custom Command under File Menu .. good, this is what I expect. but after I save the document and reopen the document again, The same Custom command show up again under File Menu in the same position as If it was never deleted!!! Any Help would be appreciated. |
#2
|
|||
|
|||
Hi
nay chance this document contains macro code which creates this menu entry? -- Regards Frank Kabel Frankfurt, Germany "EXCEL CUstomization" schrieb im Newsbeitrag ... I have a Excel Document that contain many macros and it was protected. I unprotected the doucment and deleted all macros but when I tried to delete a Custom command from FILE MENU under customize/rearrange commands, I would not see the custom Command under File Menu .. good, this is what I expect. but after I save the document and reopen the document again, The same Custom command show up again under File Menu in the same position as If it was never deleted!!! Any Help would be appreciated. |
#3
|
|||
|
|||
How did you delete the macros?
Any event code in ThisWorkboo module would not be seen in the ToolsMacroMacros listing. Menu builds are usually placed in the Workboo_Open sub in ThisWorkbook. You cannot simply remove as you would a General Module. You must go in and EditClear the code. Gord Dibben Excel MVP On Mon, 6 Dec 2004 13:29:05 -0800, "EXCEL CUstomization" wrote: I have a Excel Document that contain many macros and it was protected. I unprotected the doucment and deleted all macros but when I tried to delete a Custom command from FILE MENU under customize/rearrange commands, I would not see the custom Command under File Menu .. good, this is what I expect. but after I save the document and reopen the document again, The same Custom command show up again under File Menu in the same position as If it was never deleted!!! Any Help would be appreciated. |
#4
|
|||
|
|||
Don't know what a WorkBoo is but you could translate as WorkBook<g
Gord On Mon, 06 Dec 2004 17:29:14 -0800, Gord Dibben <gorddibbATshawDOTca wrote: How did you delete the macros? Any event code in ThisWorkboo module would not be seen in the ToolsMacroMacros listing. Menu builds are usually placed in the Workboo_Open sub in ThisWorkbook. You cannot simply remove as you would a General Module. You must go in and EditClear the code. Gord Dibben Excel MVP On Mon, 6 Dec 2004 13:29:05 -0800, "EXCEL CUstomization" wrote: I have a Excel Document that contain many macros and it was protected. I unprotected the doucment and deleted all macros but when I tried to delete a Custom command from FILE MENU under customize/rearrange commands, I would not see the custom Command under File Menu .. good, this is what I expect. but after I save the document and reopen the document again, The same Custom command show up again under File Menu in the same position as If it was never deleted!!! Any Help would be appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
My file menu is not on the menu bar. | Excel Discussion (Misc queries) | |||
canot remove command from FILE MENU | Excel Discussion (Misc queries) | |||
XML Source Menu Item disabled?? File version?? | Excel Discussion (Misc queries) | |||
Convert text file to MS_Excel | Excel Discussion (Misc queries) | |||
How do I Delete a file from the drop down file menu? | Excel Worksheet Functions |