View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.newusers
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default 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.