Macro/Custom Button

[BNieds]

Hi:

I have associated several custom buttons to macros and now I would like
to move them to a new computer. Is the definitions of these custom
buttons located in the registery file or a seperate Execl file?

Original computer uses excel 97 with Win98. New computer is Vista with
new version of excel

Thanks
bnieds

 

[Dave Peterson]

If you mean you added buttons to a commandbar, then no. These modifications (in
xl2003 and below) are stored in a file that has an extension of *.xlb. (I don't
recall the file name for xl2007.)

But these excel toolbar files are not compatible across versions.

If you created these buttons and assigned the macros manually, then you may find
your life becomes much easier by using code to do this work.

You can include code to create the toolbar when the workbook is opened and
include code to destroy the toolbar when the workbook is closed.

For additions to the worksheet menu bar, 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)

===
If you use this technique in xl2007, you won't find your toolbar displayed like
in previous versions. It'll be under the Addins tab.

 

[BNieds]

Hi:

Did the commandbar exist in Excel 97 or did 97 just have menubars and
toolbars? AT any rate from the Tools-Customize menu I select Commands
and then scroll to Macro and drag Custom Button onto the Formatting
toolbar. I then Edit the Custom Button and assign a macro to it and I
also change the Icon for the button.

This infromation has to be stored someplace within Excel since any new
worksheet I open contains the appropriate buttons. I know I can recreate
this in the new version of Excel without lots of effort and that is
probably what I will do.

Thanks for the response.
bnieds

 

[Dave Peterson]

xl97 had commandbars.

Modifications to these commandbars are stored in your *.xlb file. But these
*.xlb files are not interchangeable between versions of excel.

 

[Gord Dibben]

Dave

I renamed my Excel10.xlb to Excel11.xlb when I upgraded from 2002 to 2003.

No problems at all except for a few missing menu options that 2003 had like
Data>Create List which I soon rectified by further customization.


Gord

 

[Dave Peterson]

I tried to do this when going from xl97 to xl2k. It didn't work. Actually, the
icons looked fine, but the functions didn't do what they used to do.

I'm not sure if you got lucky with the subset of icons that you used on your
toolbar, but I wouldn't do this and trust it to work.

IIRC, Jim Rech posted something about transitioning from xl2k to xl2002 (or some
upgrade) and MS decided not to transfer the toolbar in the upgrade.

One of the reasons was that since there were a bunch new icons, users should
review the new ones and decide which they should keep or remove or add.

 

[Gord Dibben]

OK

I'm happy with mine but perhaps others might not get the same results so I won't
recommend it.


Gord