Deleting custom Commands from File Menu are nor saved next time w.

  • Thread starter EXCEL CUstomization
  • Start date
E

EXCEL CUstomization

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.
[email protected]
 
G

Gord Dibben

How did you delete the macros?

Any event code in ThisWorkboo module would not be seen in the
Tools>Macro>Macros 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
Edit>Clear the code.

Gord Dibben Excel MVP
 
Top