Excel Tool Bar (Excel 2002)

Topic

New Reply

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.

Reply | Quote

Replies

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.

Reply | Quote

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.

Reply | Quote

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 Systematic Approach to Behavioral Problems in XL helps.

Reply | Quote

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 Systematic Approach to Behavioral Problems in XL helps.

Reply | Quote

Check out this post:
post 333173

Reply | Quote

Check out this post:
post 333173

Reply | Quote

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.

Reply | Quote

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.

Reply | Quote

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.

Reply | Quote

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.

Reply | Quote

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.

Reply | Quote

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?

Reply | Quote

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

Reply | Quote

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!

Reply | Quote

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

Reply | Quote

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

Reply | Quote

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!

Reply | Quote

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

Reply | Quote

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?

Reply | Quote

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.

Reply | Quote