How do I uhide the MENU bar?

R

Robert

I had been using the MACRO tutorial s on line.

After I came back to a spread sheet of my own I could not find my Menu Bar;
FILE EDIT FORMAT...etc
 
D

Dave Peterson

I don't know what the tutorials did, but you may want to try:

Tools|customize
put a check mark in front of "worksheet menu bar"

If that doesn't work...
hit alt-f11 to get to the VBE
hit ctrl-g to see the immediate window
type this and hit enter:
application.CommandBars("worksheet menu bar").Enabled = true

Then back to excel to see if that helped.
 
R

Robert

Dave Thank you very much for responding to my predicament.
After several attempts and getting frustrated your first suggestion worked
after resetting the "worksheet menu bar"

Back on track, thankyou.
 
Top