Results 1 to 9 of 9
  1. #1
    5 Star Lounger Lou Sander's Avatar
    Join Date
    Jun 2002
    Location
    Pittsburgh, PA
    Posts
    855
    Thanks
    140
    Thanked 10 Times in 9 Posts

    Clobbered Autocorrect Options (2002)

    When I go to Tools > Autocorrect Options, I get the Basic Search pane instead of the Autocorrect Options dialog box. This happens on my old WIN98 computer and on my brand-new WINXP system. I transferred my toolbars from the old computer to the new one, so there's no mystery as to why the problem shows up on both.

    My toolbars are fairly heavily customized, but I don't find any reason for this problem when I look at them in Customize view. The way I discovered the problem is that on the old computer I had disabled automatic turning of email addresses into hyperlinks. On the new one this wasn't happening, and when I went to fix it, I couldn't. (As I recall, maybe incorrectly, the key to disabling automatic hyperlink generation is somewhere in the autocorrect realm.)

    Anybody know what might be causing the problem?
    Lou Sander
    Pittsburgh, Pennsylvania
    USA

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

    Re: Clobbered Autocorrect Options (2002)

    Toolbar customizations for Excel 2002 on Windows XP are stored in

    Cocuments and Settings<username>Application DataMicrosoftExcelExcel10.xlb

    What happens if you move this file (temporarily) to another location, or rename it? You might also take a look at Pieterse's <!post=Systematic Approach to Behavioral Problems in XL,290455>Systematic Approach to Behavioral Problems in XL<!/post>.

  3. #3
    5 Star Lounger Lou Sander's Avatar
    Join Date
    Jun 2002
    Location
    Pittsburgh, PA
    Posts
    855
    Thanks
    140
    Thanked 10 Times in 9 Posts

    Re: Clobbered Autocorrect Options (2002)

    Thanks for your help. The problem evidently was a corrupted Excel10.xlb file -- I renamed it and the problem went away. So did my highly customized toolbars, unfortunately.

    Now I am rebuilding my toolbars and a new Excel10.xlb. I need to put separators between several buttons and menu items, but I can't remember how to do it. Can you help?
    Lou Sander
    Pittsburgh, Pennsylvania
    USA

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

    Re: Clobbered Autocorrect Options (2002)

    While in customize mode, right-click a toolbar button or menu item. From the context menu, select Begin a Group (see screenshot). This will insert a separator to the left or above the selected item. Alternatively, drag the button slightly to the right or menu item slightly down.

    When you have re-created all your customizations, make a backup copy of your Excel10.xlb. If the working copy ever becomes corrupt again, you can simply replace it by the backup copy.

  5. #5
    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: Clobbered Autocorrect Options (2002)

    In addtion to Hans' suggestion, another way is (while in "customization") is to just click on the toolbar button and move it slightly to the right. Excel will add the "group"

    Steve

  6. #6
    5 Star Lounger Lou Sander's Avatar
    Join Date
    Jun 2002
    Location
    Pittsburgh, PA
    Posts
    855
    Thanks
    140
    Thanked 10 Times in 9 Posts

    Re: Clobbered Autocorrect Options (2002)

    Ah, yes! How easy it is to forget these little things when you don't use 'em regularly.

    Thanks.
    Lou Sander
    Pittsburgh, Pennsylvania
    USA

  7. #7
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Clobbered Autocorrect Options (2002)

    You could also attach the custom toolbars you like to a workbook. SHould your xlb get corrupted again, just delete it and open the workbook with the attached toolbars.

    You do need to create custom toolbars to be able to attach them though.

    What I did was create a copy of the standard toolbar by adding a custom bar and control-dragging all the buttons I liked to the new bar. Added some extra ones and attached the custom bar to a workbook. Then I hid the standard bar and showed my new custom bar.

    Any time I need my custom bar again, I simply open the workbook I attached it to.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  8. #8
    5 Star Lounger Lou Sander's Avatar
    Join Date
    Jun 2002
    Location
    Pittsburgh, PA
    Posts
    855
    Thanks
    140
    Thanked 10 Times in 9 Posts

    Re: Clobbered Autocorrect Options (2002)

    Good idea. How does one attach a toolbar to a workbook?
    Lou Sander
    Pittsburgh, Pennsylvania
    USA

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

    Re: Clobbered Autocorrect Options (2002)

    Make sure that the workbook to which you want to attach the custom toolbar is the active workbook when you select Tools | Customize...

    There is an "Attach..." button in the Toolbars tab of the Customize dialog.

Posting Permissions

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