View Full Version : how let the custom menu start with excel opened?

08-25-2005, 01:46 AM
I found if I opened the excel file,then a custom menu also out,and when I delete the custom menu,and close the excel file ,but when I reopen the file, the custom menu reappear again,but actually this file doesn't inclued any macros,so it's strange
who can help to explain it,and it's arrreciated if you can tell me how to do some modification to this custom menu,just like name changed.

08-25-2005, 02:18 AM
Hi helai :hi: ,

Your right, the workbook doesn't have any macros, but it did have:

The reason why a custom menu item (30 Days pick up) appears on the main menu is because at some point someone put it there by customizing the worksheet menu bar.

You can reset this by:
Click on Tools
Then click Cusomize
In the Toolbars tab under Toolbars, select Worksheet Menu Bar so it's highlighted.
Then press the Reset button.

If you want to change the wording of the custom menu item:
While you have the Customize dialog open:
Click on 30 Days pick up (or any menu item) or Right click on it to bring up various options.

Hope this helps.


08-25-2005, 02:44 AM
To reset the menu bar via VBA:

CommandBars("Worksheet Menu bar").Reset


08-25-2005, 04:59 PM
Thanks for your reply,

I think yours advice is enough to change or modife the normal custom menu,but this custom is special,you can try it,although seems you have delete the custom menu,but when you reopen the file,the menu restore again
you can try it

I want to know how to create this kind of custom menu,no marcro writted