Home |
Search |
Today's Posts |
#1
|
|||
|
|||
menu commands are gray
When making a new file, commands are okay. I have a file I update once per
month, however now some of the menu options are grayed out. Worksheet is not protected. Can anyone help me? |
#2
|
|||
|
|||
kcohio
You don't say which items are grayed out, so just guessing here. Possibly you have two or more sheets "grouped" as in selected? Do you see [Group] behind the filename in title bar? Note which sheets are grouped. The sheet tabs will be white. Then right-click on any sheet and "ungroup". Note: check your data carefully on any sheets that were grouped. What you have done to one will have been done to others. Also, if the workbook is protected, some menu items are unavailable. Gord Dibben Excel MVP On Sun, 5 Dec 2004 11:23:02 -0800, kcohio wrote: When making a new file, commands are okay. I have a file I update once per month, however now some of the menu options are grayed out. Worksheet is not protected. Can anyone help me? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Non-functional Popup Menu Boxes | Charts and Charting in Excel | |||
How can I add "File" to my menu? | Excel Discussion (Misc queries) | |||
XML Source Menu Item disabled?? File version?? | Excel Discussion (Misc queries) | |||
How to restore menu bar in microsoft word? | Excel Discussion (Misc queries) | |||
How to remove an Excel Main Menu item inserted by .xla file | Excel Discussion (Misc queries) |