How do I find the Worksheet Menu bar in Excel if that is missing?

[Bob Phillips]

Go to the VBIDE (Alt-F11), open the immediate window (Ctrl-G) and type

Application.Commandbars(1).Enabled = True

and Enter

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

 

[wbez]

Thanks, work like a bomb.

Go to the VBIDE (Alt-F11), open the immediate window (Ctrl-G) and type

Application.Commandbars(1).Enabled = True

and Enter

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

 

[Bob Phillips]

What, you mean it blew your PC up. Sorry <vbg>

Bob

 

[GT]

Thanks bob, after 2 hours of frustration, that worked like a dream! GT