Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How do I reset the configuration of the Excel Options?
I opened a worksheet with macro and the configuration changed.
I want to set into default (original) again. |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How do I reset the configuration of the Excel Options?
What do you mean by "configuration"?
Menus and Toolbars have been changed? Sheet format has been changed? To get back to what you perceive as "default" we would have to know a few more details. What does a new workbook look like? Is it changed also? Gord Dibben MS Excel MVP On Fri, 8 Dec 2006 10:17:01 -0800, Junior wrote: I opened a worksheet with macro and the configuration changed. I want to set into default (original) again. |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How do I reset the configuration of the Excel Options?
For example, in the Excel option Menu, Advanced, Editing options exits the
following option? "After pressig enter, move selection" After the openning of the file with macro, this options changed. Some others options changed too. What could I do to have back all the options as original? Junior Storani "Gord Dibben" wrote: What do you mean by "configuration"? Menus and Toolbars have been changed? Sheet format has been changed? To get back to what you perceive as "default" we would have to know a few more details. What does a new workbook look like? Is it changed also? Gord Dibben MS Excel MVP On Fri, 8 Dec 2006 10:17:01 -0800, Junior wrote: I opened a worksheet with macro and the configuration changed. I want to set into default (original) again. |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How do I reset the configuration of the Excel Options?
Junior
I don't understand "Excel option menu, Advanced" but I think you mean ToolsOptionsEdit Some of those items are workbook specific, some are window or sheet specific and others are global. Unfortunately, Excel stores those global options in the Registry so they are already saved there. You will have to go into ToolsOptionsEdit and change the "move selection after enter" to whatever direction you want and to each dialog tab and change to your liking the individual items. If any menu or toolbar items were changed you can reset them to original by going to ToolsCustomizeToolbars. Select whichever and "reset" Gord Dibben MS Excel MVP On Fri, 8 Dec 2006 12:51:02 -0800, Junior wrote: For example, in the Excel option Menu, Advanced, Editing options exits the following option? "After pressig enter, move selection" After the openning of the file with macro, this options changed. Some others options changed too. What could I do to have back all the options as original? Junior Storani "Gord Dibben" wrote: What do you mean by "configuration"? Menus and Toolbars have been changed? Sheet format has been changed? To get back to what you perceive as "default" we would have to know a few more details. What does a new workbook look like? Is it changed also? Gord Dibben MS Excel MVP On Fri, 8 Dec 2006 10:17:01 -0800, Junior wrote: I opened a worksheet with macro and the configuration changed. I want to set into default (original) again. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
When excel is opened, Insert, Format, Data options greyed out. | Excel Discussion (Misc queries) | |||
Running Excel 2000 VBA Application on Excel 2003 | Excel Worksheet Functions | |||
Using Excel 2000 VBA Application on Excel 2003 | Excel Worksheet Functions | |||
Excel should heavily extend the options for black-white charts | Charts and Charting in Excel |