The question indicates somewhere else,but not clear if that
means somewhere else in the toolbars or to be installed on
another machine.
The main problem is the toolbar buttons that were custom made
if he is transferring them to another machine.
I have a program to do the opposite of John Walkenbach's
menu maker so one can download the toolbars. I just did it
yesterday only to find that I must have already have done it
before, because the when I ran the macro it actually created
the spreadsheet. You have to enter the menu placement number
you want into column B for a level of 1. Then use J-W's
menu maker with a couple of changes if you want it permanent.
-- remove code in ThisWorkbook in the menumaker project
-- change Temporary from True to False in the code module for menumaker.
Goes very fast, but the icons you see in the menu will be the
original buttons. You will have to copy and paste each of
those buttons with what I have.
http://www.mvps.org/dmcritchie/excel/barhopper.htm
http://www.mvps.org/dmcritchie/excel/code/barhopper.txt
for my stuff I had all my toolbar buttons on my webpage
http://www.mvps.org/dmcritchie/excel/toolbars.htm
You can copy a button from customize and paste button in customize.
You can copy from anywhere but excel and paste button in customize.
If you copied the buttons to Excel sheet, you will have to leave customize
each time to copy the next button, before you paste into cutomize when
restoring buttons.
What would help would be to paste the buttons into anything, or
copy them to a file, if possible so they can be picked up in a restore.
I think Excel 2003 keeps track of your buttons assigning them a
number, but I don't know if you can really use that, except for
creating another toolbar on same system, in which case my macro
should work as it is, when it's output is reinputted with MenuMaker.
As I said I had originally finished it once before because the code page
should produce the worksheet. So ignore the doubleclick event macro
I just added today it shouldn't have been needed. I'd forgotten how far
I'd gotten because I couldn't use it because of the buttons.
But when you
lose Excel 2000 and can't bring it up, and Excel 2002 only brought up
the menu structure but not the macros, it turns out to be good enough,
to use and I regenerated so my 419KB (about 500KB converted to 2002)
..xlb file became 58KB on Excel 2002 when regerate, which is about what
you experienced some time back (least I think it was you)..
My toolbars
were from Excel 95 and Excel 2000 did not do a good job of converting,
but I thought it was too much work to fix -- should have done it a long
time ago -- you never risk things when they work. When things are
broke you can work with them. Used the file on my system but it applies
to backups in general, backup things even if you don't know how to use
the backup (as in your address book) when you need to restore it, you'll
figure it out.
http://www.mvps.org/dmcritchie/excel/backup.htm
and if you don't have a backup, at least make a backup before you
mess it up when trying to fix. Copied my .xlb to a pen drive and
didn't need it (except to look up the sizes).
