Missing Menu Bar - Excel 2000

I

Ian

I have a situation where the menu bar has disappeared. I
closed and re-opened Excel, checked to see if the menu bar
has been hidden but with no luck. Is there some kind of
refresh process that can be tried to re-activate the menu
bar? I could not find anything in Excel help.

Any help will be appreciated.

Thanks,

Ian
 
N

Norman Harker

Hi Ian!

With a workbook open, use ALT+F11 [Gets you to the Visual Basic
Editor (VBE)]

View > Immediate window

Copy/paste or type the code line below into the Immediate window and
then press ENTER

Application.CommandBars("Worksheet Menu Bar").Enabled = True

To get back to Excel press Alt+Q

Hope that you will now breathe a sigh of relief.
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
[email protected]
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
I

Ian McIntosh

Excellent! Thanks Norman.

Ian

-----Original Message-----
Hi Ian!

With a workbook open, use ALT+F11 [Gets you to the Visual Basic
Editor (VBE)]

View > Immediate window

Copy/paste or type the code line below into the Immediate window and
then press ENTER

Application.CommandBars("Worksheet Menu Bar").Enabled = True

To get back to Excel press Alt+Q

Hope that you will now breathe a sigh of relief.
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
[email protected]
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
I have a situation where the menu bar has disappeared. I
closed and re-opened Excel, checked to see if the menu bar
has been hidden but with no luck. Is there some kind of
refresh process that can be tried to re-activate the menu
bar? I could not find anything in Excel help.

Any help will be appreciated.

Thanks,

Ian
Click to expand...


.
Click to expand...
 
Top