View Single Post
  #5  
Old July 24th, 2008, 11:02 PM posted to microsoft.public.excel.setup
Griffinspc
external usenet poster
 
Posts: 6
Default Excel toolbar customization

I do have one. Weird when searching for either the full name or *.xlb it
doesn't find it but navigating to it does so with that I renamed it OLD and
made some obvious changes and closed Excel. I waited and opened it and had a
brief glimpse of my changes; Close and Save As in text so it would be easy to
spot and then the Toolbar flashed and went back to the default. But if I open
the new Excel11.xlb file it has my changes. Color me stumped.

"Gord Dibben" wrote:

You must have one.

In My ComputerToolsFolder OptionsView do you have "hide extensions for
known file types" checkmarked.

Uncheck and try a search for *.xlb


Gord

On Thu, 24 Jul 2008 10:51:03 -0700, Griffinspc
wrote:

Thanks for the reply. Interesting. I have no xlb file on this machine at all.

"Gord Dibben" wrote:

Customized changes to to menus and toolbars are saved in Excel11.xlb

Usual path is

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

Your path may differ

Maybe you don't have permission to save to that folder

Search for Excell11.xlb using Windows search.

When found, re-name to Excel11.OLD

Restart Excel and make some changes. Excel will create a new *.xlb file

Double-click to open it. Does this one have your changes?


Gord Dibben MS Excel MVP


On Thu, 24 Jul 2008 08:04:00 -0700, Griffinspc
wrote:

I have modified my Excel toolbars many times with no problem however on this
new machine at work with Office 2003 and all service packs, etc., the changes
I make are not retained when i close and open Excel. I've tried the Detect &
Repair and looked for any Office updates and all are current. Help.