Custom Tooolbars

[Guest]

I created a custom toolbar and also added a few custom buttons and assigned
macros to those buttons. I got a checkdisk error when booting up the other
day and when I went into Excel my custom toolbar and macro buttons were gone.
What is the file that that info is stored in? Is it a .xlb file?
I recreated everything but would like to back up that file incase that
happens again.

Thanks.

 

[Dave Peterson]

Toolbar settings are stored in your *.xlb file. (Location and name vary with
versions of Windows and excel.)

But if you search for *.xlb and you find more than one, you can use the one with
the most current date (the date you last modifed a toolbar). I'd delete the
rest and backup that latest file.

But instead of creating the toolbar manually, you could do it in code:

I really like the way John Walkenbach does it in his menumaker workbook:
http://j-walk.com/ss/excel/tips/tip53.htm

Here's how I do it when I want a toolbar:
http://www.contextures.com/xlToolbar02.html
(from Debra Dalgleish's site)