Custom Toolbar

[sunroyal]

i JUST SPENT 4 HOURS BUIDING A TOOLBAR. I HAD AUTOSAVE ENABLED FOR EVERY
10 MINUTES. EXCEL 97, WINDOWS 95 (ILLEGAL OPERATION ERROR SHUT ME DOWN
AND NOW MY TOOLBAR IS GONE. CAN I GET IT BACK, OR SHOULD I START
DRINKING NOW!!?

 

[Dave Peterson]

I think it's time to start drinking.

As far as I know, excel saves the toolbar when you're exiting (not crashing)
excel.

Next time, do a few customizations, exit excel. Find your *.xlb file that was
just updated (use windows|Find if you need to).

And back it up nicely.

Then back to excel for a few more minutes/hours of customization.

 

[rob nobel]

Hi Dave,
Just had a look into this post and wonder if the .xlb file is like the
Normal.dot that stores all the Word settings?
Does Excel look for and load the xlb file at each start up of excel?
Rob

I think it's time to start drinking.

As far as I know, excel saves the toolbar when you're exiting (not crashing)
excel.

Next time, do a few customizations, exit excel. Find your *.xlb file that was
just updated (use windows|Find if you need to).

And back it up nicely.

Then back to excel for a few more minutes/hours of customization.

 

[Dave Peterson]

Normal.dot stores a lot of stuff that *.xlb doesn't. *.xlb is a file that only
contains the customized toolbar modifications.

normal.dot contains all the default formatting (tabs, margins, fonts) for a new
word document.

This formatting stuff in xl is either stored in the registry or in book.xlt (in
your XLStart folder).

(Sheet.xlt in XLStart is the template for new sheets added to existing
workbooks.)

And yes, excel will use that *.xlb file when it starts.

(And that's another file (normal.dot) that should be backed up, too!)

Hi Dave,
Just had a look into this post and wonder if the .xlb file is like the
Normal.dot that stores all the Word settings?
Does Excel look for and load the xlb file at each start up of excel?
Rob

 

[rob nobel]

Thanks Dave. All good! I have always backed up normal.dot but never it's
equivelent for Excel, but the picture is becoming more complete.
Rob

Normal.dot stores a lot of stuff that *.xlb doesn't. *.xlb is a file that only
contains the customized toolbar modifications.

normal.dot contains all the default formatting (tabs, margins, fonts) for a new
word document.

This formatting stuff in xl is either stored in the registry or in book.xlt (in
your XLStart folder).

(Sheet.xlt in XLStart is the template for new sheets added to existing
workbooks.)

And yes, excel will use that *.xlb file when it starts.

(And that's another file (normal.dot) that should be backed up, too!)