worksheet menu bar
 

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

worksheet menu bar
 

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.


--
Rob van Gelder - http://www.vangelder.co.nz/excel


"Spike" wrote in message
...
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

worksheet menu bar
 

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" wrote:

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.


--
Rob van Gelder - http://www.vangelder.co.nz/excel


"Spike" wrote in message
...
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

worksheet menu bar
 

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

--
Rob van Gelder - http://www.vangelder.co.nz/excel


"Spike" wrote in message
...
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" wrote:

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.


--
Rob van Gelder - http://www.vangelder.co.nz/excel


"Spike" wrote in message
...
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