ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   toolbars keep appearing on opening excel after I removed them bef. (https://www.excelbanter.com/excel-discussion-misc-queries/994-toolbars-keep-appearing-opening-excel-after-i-removed-them-bef.html)

toolbar hater

toolbars keep appearing on opening excel after I removed them bef.
 
I uncheck a toolbar in "customize" but it's back when I open excel again. help

Gord Dibben

bar

Manual customizations to Toolbars and Menus are saved in a file named *.XLB

XL2000 and 2002 *.xlb file will be in Documents and
Settings\yourname\application data\microsoft\Excel and be Excel9.xlb
or Excel10.xlb

Excel 97 in C:\Windows and named username.XLB

Excel 2003 same as 2000 and 2002 and named Excel11.XLB

Perhaps this file is going astray? If on a server, this can happen.

Also if on a server, you may not have permissions to save. See your IT guy or
Administrator.

Search for *.xlb and see what you come up with. When you get your
customization done, make a backup copy of the *.xlb file.

When you search for *.xlb you may come up with more than one. Make some
changes to your Toolbar or Menu then save and close Excel.

Check to see which *.xlb updated. That would be the one to backup.

One more thing about the *.XLB file. If it gets too large(30kb) I hear it
can start causing problems.


Gord Dibben Excel MVP

On Wed, 1 Dec 2004 16:35:01 -0800, "toolbar hater" <toolbar
wrote:

I uncheck a toolbar in "customize" but it's back when I open excel again. help




All times are GMT +1. The time now is 11:10 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com