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 wrote:
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 wrote:

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