Menus went away
Posted by Jo on January 18, 2002 12:01 PM
We have a computer at our office that all of the File,Edit,View, etc. menu went away. Please how do we fix this? I've tried it all. (except the right way of course).
Posted by Gary Bailey on January 18, 2002 12:12 PM
Right click on the menus at the top. Choose Customize. Make sure "Worksheet Menu Bar" is ticked.
Gary
Posted by Michael on January 18, 2002 12:17 PM
I can at least tell you what happened (most likly)
Go to a machine and go to
view
toolbars
custom
->under customize you will notice the Worksheet Menu Bar
This is the toolbar that is missing.
Now, to get it back
Go to help and type in worksheet menu tool bar
Hopefully somewhere in the answer they will mention custom toolbars, select that and then click either how or show me. That should place you in the general ballpark of where you need to be to re-select the Worksheet Menu Bar.
Posted by Jo on January 18, 2002 12:22 PM
I checked, It's checked, but nothing still (nt)
Posted by Gary Bailey on January 18, 2002 12:30 PM
Re: I checked, It's checked, but nothing still (nt)
Try deleting the xlb file. It holds all the customizations made to the menus. Note - you'll lose any customizations you may have made.
Search the C: drive for *.xlb.
Gary
Posted by Richard Winfield on January 18, 2002 1:20 PM
Another possibility is that that machine was running a spreadsheet in Excel that had a macro that turned off the worksheet menu bar, and then neglected to turn it back on. Try pasting the following into the workbook_activate module
Sub autoopen
CommandBars("Worksheet Menu Bar").Enabled = True
End sub
Don't know if this will help but it is worth a try.
Rick
