worksheet menu bar

[Guest]

I have lost the 'Edit' button from the worksheet menu bar. How do you get it
back. I have tried to write some code without success.

Can anyone help?

Many thanks

Spike

 

[Rob van Gelder]

Make sure the menu is showing (not a chart menu or anything, just a standard
menu)

in VB:
CommandBars.ActiveMenuBar.Reset

Manually:
I'm running Excel 2003 - I can rightclick the toolbar, select Customize.
From the Options tab, select reset menu.

 

[Guest]

Absolutely brilliant, many thanks i had tried manually without success and
code wise was going down the 'application.commandbars ' etc which is where i
was going wrong.

Thanks again, most grateful

Happy Christmas

Spike

 

[Rob van Gelder]

Just be aware that ActiveMenuBar changes depending on what is selected.