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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
(e-mail address removed)
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top