MrExcel.com - Your One Stop for Excel Tips & Solutions

Please Help

Posted by Roy on August 18, 2001 5:13 AM

I have managed to hide the worksheet menu bar but i cannot get it to re-appear. The macro which should return it runs without errors but the worksheet menu bar does not appear.
Can anyone help with this. I am using the following
Application.CommandBars("Worksheet Menu Bar").Enabled = True

Thanks
Roy

Posted by Ivan F Moala on August 18, 2001 5:29 AM

Try
Application.Commandbars("worksheet Menu").Visible= True

If this doesn't get it then Right click on comandbars....Select Customize | Toolbars
The scroll down to Worksheet menu bar.
Click the option button.


Ivan