Cannot Customize Excel Toolbar
I deleted the .mlb files. There were 2 for excel. I went back and made sure
they were gone and they were. I then went to Excel and tried to customize
the toolbar again. Again when I went out of the program and back in again,
the customization to the toolbar was gone.
"Dave Peterson" wrote:
I think you did something wrong when you tried it.
Maybe you could give some details of what you tried and how it failed.
Sue T. wrote:
I tried that and it didn't work. I had I.S. over here yesterday and they
couldn't figure it out.
"Dave Peterson" wrote:
Customized changes to toolbars are saved in a file with an extension of *.xlb.
You could lack the authority to save to this file, but my bet is that you have
multiple *.xlb files and the one you're changing is not the one that excel
finally uses.
I'd do this:
Close excel.
Use windows start button|search to find all the *.xlb files and delete them.
Remember to look in hidden folders, too.
Then reopen excel and make a change to the toolbar (just to test). Then close
excel and reopen. If the change stuck, finish up your customizations.
If you can't find *.xlb using windows start button|Search, then you could use an
old DOS command to search and delete them.
Windows Start button|Run
type:
CMD
(to get to the Command prompt)
C:
(to get to the C: drive--change this to the drive that excel is installed on)
cd\
(to get to the root directory)
dir *.xlb /s
The /s says to search subfolders, too.
Make a note of the locations of the found files and then delete those files.
Sue T. wrote:
I have been trying to customize the standard toolbar to accept close, exit,
etc., but once I close excel and go back in the changes are not saved.
All my other "office" programs work fine, except for excel.
--
Dave Peterson
--
Dave Peterson
|