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.
|