EXCEL BASIC PARAMETERS

  • Thread starter Thread starter Bobby
  • Start date Start date
B

Bobby

Hi,
Could someone tell me the name of the file or files that contains
EXCEL information on the toolbar? I have 2 computers and I don't want
to recreate the buttons in my EXCEL on the second computer, that I
created on the toolbar of the first computer.
Thank's ahead.
 
*.xlb

the wildcard (*) is depending on your Excel version, you can search for it
using advanced search (search hidden files or folders) using the wildcard


--


Regards,


Peo Sjoblom
 
Excelxx.xlb is the file that stores your Menu and Toolbar customizations where
xx is your version of Excel.

8 is 97
9 is 2000
10 is 2002
11 is 2003

But...as this file gets more customizations it tends to bloat and cause
problems.

You are far better off to create your Toolbar and customizations "on the fly"
from Personal.xls or an add-in.

See Debra Dalgleish's site for Dave Peterson code for creating Toolbars

http://www.contextures.on.ca/xlToolbar02.html

John Walkenbach's MenuMakr workbook also shows how to add items to menus.

http://www.j-walk.com/ss/excel/tips/tip53.htm


Gord Dibben MS Excel MVP
 
Back
Top