Results 1 to 11 of 11
  1. #1
    New Lounger
    Join Date
    Jul 2002
    Posts
    13
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Excel Tool Bar (Excel 2002)

    I have been experiencing a situation where my tool bar seems to randomly revert back to the default settings. When this happens all user custom buttons/macros disappear and if the setting is 2 rows it reverts back to 1 row. The row change is not a biggie but recreating the custom buttons is.
    I am not able to determine what is causing this does anyone have an idea? I am running on Windows XP.

  2. #2
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel Tool Bar (Excel 2002)

    One possibility is a rude macro that resets the tool bar back to its default configuration without worrying about any customizations. That's why I always put my customizations in a custom tool bar.
    Legare Coleman

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

    Re: Excel Tool Bar (Excel 2002)

    Your tool bar customizations are stored in a file named Excel10.xlb. This file sometimes becomes corrupt. You migh try removing or renaming this file, then customize the toolbar again, and see if the modifications stick. You can also see if Pieterse's <!post=Systematic Approach to Behavioral Problems in XL,290455>Systematic Approach to Behavioral Problems in XL<!/post> helps.

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

    Re: Excel Tool Bar (Excel 2002)

    Check out this post:
    <post#=333173>post 333173</post#>
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  5. #5
    New Lounger
    Join Date
    Jul 2002
    Posts
    13
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel Tool Bar (Excel 2002)

    Thanks for the input . However here's some additional info
    Recently because of this happening I gave up on recreating the buttons and just run the macros through the menu as needed.
    My only change would be to reset the tool bar to 2 lines (cause I like it hat way) and without running macros it will periodically reset itself to 1 line.
    BTW - this is occuring on different machines with different people here where I work and we are using stand alone copies of the s/w.

  6. #6
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel Tool Bar (Excel 2002)

    It could be a macro that is getting executed automatically when Excel starts up. If so, then Jan Karel's Post will isolate the culpret. Again, if you put your customizations in a custom tool bar, the macro might not mess with them.
    Legare Coleman

  7. #7
    5 Star Lounger
    Join Date
    May 2001
    Location
    Philadelphia, Pennsylvania
    Posts
    676
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel Tool Bar (Excel 2002)

    I had a similar problem over the summer and posted a question here and got good suggestions. Yet I still had the problem and I started the "make one change and find the file" game to spot *where* Excel's .xlb file was located. In my particular environment, there were a few .xlb spots around. I noted that in my case there was >>no<< ...10.xlb-named file. So I named it myself. I fiddled around with those games and eventually, somehow, Excel started to recall a customized toolbar. But it still loses new customizations. I just don't have time to fiddle with it again, but you might try that approach.

  8. #8
    2 Star Lounger
    Join Date
    Sep 2002
    Location
    Birmingham, England
    Posts
    123
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel Tool Bar (Excel 2002)

    Still on Toolbars, but tangentially, is there a way of eg removing 3 from the workspace and revealing 2 different ones other than doing each of them one at a time?

  9. #9
    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: Excel Tool Bar (Excel 2002)

    I am not clear on what you are asking. If you want to know if you can remove toolbars and put others in its place, you can do it one time manually and the setup should stay. If you want to routinely switch back- and forth, you could create a macro to remove the 2 and add the other 2, then have it reverse it when run again. It is the Visible property of the commandbars object.

    The macro recorder can give you the objects.
    Steve

  10. #10
    2 Star Lounger
    Join Date
    Sep 2002
    Location
    Birmingham, England
    Posts
    123
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel Tool Bar (Excel 2002)

    Thanks, Steve, more of an irritation than a problem.
    Would be nice to make the changes in just one visit to the View | Toolbars, but there are plenty of better things to worry about!

  11. #11
    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: Excel Tool Bar (Excel 2002)

    Goto View - Toolbars - customize - Toolbars tab

    You will see a list of checked/unchecked toolbars. Check and uncheck as desired and then close when done.

    Steve

Posting Permissions

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