Results 1 to 8 of 8
  1. #1
    2 Star Lounger
    Join Date
    Jun 2002
    Posts
    122
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Registry Keys for Excel (2003/sp1)

    Hi there,

    Can anyone point me in the direction of the correct registry key to export if I want to change options within the Tools menu of Excel, e.g., deselect items on the View tab?

    Many thanks,

    Violet

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Registry Keys for Excel (2003/sp1)

    Not quite sure what you are after. You can do it via View - toolbars - cusomize direcly in Excel.

    XL-VB can also modify it in code if desired. It does not require any registry changes

    Steve

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Registry Keys for Excel (2003/sp1)

    Most of those options are stored in

    HKEY_CURRENT_USERSoftwareMicrosoftOffice11.0ExcelO ptions

    (11.0 is the version number for Office 2003; for Office XP, it's 10.0 etc.)

    Some of the values are easily readable, such as DecimalSeparator and DefaultPath, but there are also values such as Options, Options3, Options6 and Options95 that combine different settings in one number.

  4. #4
    2 Star Lounger
    Join Date
    Jun 2002
    Posts
    122
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Registry Keys for Excel (2003/sp1)

    Hi Hans,

    Specifically, I'm trying to deselect "Startup Task Pane", change the Dictionary Language to English (UK). I've just noticed, however, trying to do a similar thing with Word .reg keys I've been able to deselect some of the settings I want to, but not others like deselecting Startup Task Pane, Smart Tags and some others. Are these things which can't be deselected by .reg files perhaps?

    Thanks - look forward to your reply,

    Violet

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Registry Keys for Excel (2003/sp1)

    "Show the task pane at startup" is stored in the StartupDialog value HKEY_CURRENT_USERSoftwareMicrosoftOffice11.0ExcelO ptions. 0 = No, 1 = Yes.
    I'm not sure where specific Smart Tag settings are stored - there is a value RecognizeSmartTags in the above key, and there are some settings in HKEY_CURRENT_USERSoftwareMicrosoftOfficeCommonSmar t Tag, but I don't know their purpose.
    Do you really need to change this using registry files? A macro would be easier.

  6. #6
    2 Star Lounger
    Join Date
    Jun 2002
    Posts
    122
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Registry Keys for Excel (2003/sp1)

    I'll have a look at that now.

    I'd prefer to use a reg file - we are upgrading some 500 users' desktops over the next few weeks. When it comes to office we have a batch file which runs an .exe file to place our company templates on to users' C: drives and we also use .reg files to change certain settings and options, only within Word until now. I have a working .reg key to change some Outlook options and the .reg key I've extracted for Word changes some settings but not all.

    Any advice would be gratefully received.

    Thanks,

    Violet

  7. #7
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Registry Keys for Excel (2003/sp1)

    Word is a problem in that many settings are contained in the HKEY_CURRENT_USERSoftwareMicrosoftOffice11.0WordDa ta key, in two binary values that are not easily interpretable. You may be able to use a group policy to apply Office settings - see Administrators can use Office policy templates with the Group Policy settings of Windows, but I don't have any experience with that myself.

  8. #8
    2 Star Lounger
    Join Date
    Jun 2002
    Posts
    122
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Registry Keys for Excel (2003/sp1)

    These are the two keys I'm using for Word but, as you say, they don't do everything I want and aren't easy to breakdown! I'll try a macro, see how that goes.

    Thanks again,

    Violet

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •