Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Excel Options disabled
Years ago I created a rather involved Excel 4.0 Macro. Since then, we've
migrated to Windows Excel 2000. Somewhere in the process, I set a switch somehow that unintentionally disabled the Options functionality under the Excel Tools menu selection. It shows up under the Tools menu as active but when it is selected, no dialogue box opens. Instead the menu collapses as if the Escape key was entered. I would like to reactivate the Options functionality so I can reset some of the way Excel works (e.g. an Enter key should advance to the next row down). Any suggestions? |
#2
|
|||
|
|||
I think I'd try resetting the worksheet menu bar toolbar.
Tools|Customize|toolbars tab select the worksheet menu bar and click reset. BJohnson wrote: Years ago I created a rather involved Excel 4.0 Macro. Since then, we've migrated to Windows Excel 2000. Somewhere in the process, I set a switch somehow that unintentionally disabled the Options functionality under the Excel Tools menu selection. It shows up under the Tools menu as active but when it is selected, no dialogue box opens. Instead the menu collapses as if the Escape key was entered. I would like to reactivate the Options functionality so I can reset some of the way Excel works (e.g. an Enter key should advance to the next row down). Any suggestions? -- Dave Peterson |
#3
|
|||
|
|||
Thanks. I tried that but it did not make any difference. Any other
suggestions? "Dave Peterson" wrote: I think I'd try resetting the worksheet menu bar toolbar. Tools|Customize|toolbars tab select the worksheet menu bar and click reset. BJohnson wrote: Years ago I created a rather involved Excel 4.0 Macro. Since then, we've migrated to Windows Excel 2000. Somewhere in the process, I set a switch somehow that unintentionally disabled the Options functionality under the Excel Tools menu selection. It shows up under the Tools menu as active but when it is selected, no dialogue box opens. Instead the menu collapses as if the Escape key was entered. I would like to reactivate the Options functionality so I can reset some of the way Excel works (e.g. an Enter key should advance to the next row down). Any suggestions? -- Dave Peterson |
#4
|
|||
|
|||
You could kill the *.xlb file. (.xlb is where excel stores toolbar
customizations.) close excel then windows start button|search Search for all *.xlb files (in hidden folders, too) Rename all the *.xlb files to *.xlbOLD Start excel and see if it worked. If it did, delete those *.xlbOLD files. If it didn't work, just rename them back (no harm, no foul). BJohnson wrote: Thanks. I tried that but it did not make any difference. Any other suggestions? "Dave Peterson" wrote: I think I'd try resetting the worksheet menu bar toolbar. Tools|Customize|toolbars tab select the worksheet menu bar and click reset. BJohnson wrote: Years ago I created a rather involved Excel 4.0 Macro. Since then, we've migrated to Windows Excel 2000. Somewhere in the process, I set a switch somehow that unintentionally disabled the Options functionality under the Excel Tools menu selection. It shows up under the Tools menu as active but when it is selected, no dialogue box opens. Instead the menu collapses as if the Escape key was entered. I would like to reactivate the Options functionality so I can reset some of the way Excel works (e.g. an Enter key should advance to the next row down). Any suggestions? -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Graphing options in Excel | Charts and Charting in Excel | |||
Difference in number of Excel NewsGroups | Excel Discussion (Misc queries) | |||
Problems with Excel Horizontal arrays with regional options using. | Excel Discussion (Misc queries) | |||
Merge and Center Disabled in Excel 2003 Document | Charts and Charting in Excel |