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.

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.

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.

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.