| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can I create a worksheet menu to select each other worksheet | Excel Discussion (Misc queries) | |||
| My Worksheet Menu Bar is Gone? | Excel Discussion (Misc queries) | |||
| New Menu on Worksheet & Chart Menu Bars | Excel Programming | |||
| linking chart menu bars and worksheet menu bars | Excel Programming | |||
| chart menu bar vs worksheet menu bar | Excel Programming | |||
Linear Mode
