PDA

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



helai
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.

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

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

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.

Marcster.

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


CommandBars("Worksheet Menu bar").Reset

Marcster.

helai
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

Thanks.
helai