ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Tool bar keeps changing back after I add edit buttons (https://www.excelbanter.com/excel-discussion-misc-queries/168027-tool-bar-keeps-changing-back-after-i-add-edit-buttons.html)

MarkusB

Tool bar keeps changing back after I add edit buttons
 
I have added insert and delete rows/column buttons to my Excel tool bar - but
the tool bar keeps changing back. How do I locl the trool bar to accept my
changes?

Gord Dibben

Tool bar keeps changing back after I add edit buttons
 
Toolbar and menu customozations are saved in a file named Excelxx.XLB where xx
is your version of Excel.

Usually will be located at......................

C:\Documents and Settings\username\Application Data\Microsoft\Excel

Maybe you don't have permission to save to that folder or the folder in which is
may be stored if not that one.

Have a look for *.xlb file using Windows file search.

See where it is and note the size and date.

Make some changes in Excel to a Toolbar, close Excel and see what happens to
your *.xlb file.


Gord Dibben MS Excel MVP

On Fri, 30 Nov 2007 12:16:01 -0800, MarkusB
wrote:

I have added insert and delete rows/column buttons to my Excel tool bar - but
the tool bar keeps changing back. How do I locl the trool bar to accept my
changes?




All times are GMT +1. The time now is 03:19 PM.

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