Toolbars with diff versions of Excel

[sh]

I have a customized toolbar in Excel 2003 and want to use the same
customization in Excel 2000 without ahving to do everything rom scratch. Is
the 2003 XLB file compatible with the Excel 2000. Or is there a way to
export/import between versions?

 

[Bob Phillips]

They should work okay, especially if you create them in code at workbook
open.

Have you tried?

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[sh]

I tried loading the 2003 XLB file and Excel 2000 crashes. I had another XL
2000 (one a third machine) with the same customizations and when I tried
that one, the XL 2000 crashed.
sh

 

[Dave Peterson]

IIRC, I had the same trouble.

I think you'll have to recustomize the toolbar.

 

[sh]

I figured out a way to do it. I created a custom toolbar, pulled the custom
buttons down tothe custom toolbar, savedd the file as an XLT. Opened the XLT
in the Excell 2000, moved the custom buttons to the stadard toolbar. I had
to reassign the macros sinc ethe user names were diff on the two machines so
the aplication data was in diff dirs, but that only took a few minutes.

thanks,
sh

 

[sh]

Thaks Bob and Dave for the comments.

Going the XLT torute really saved time. By putting the custom buttons on a
custom toolbar and saving as an xlt file, the custom toolbar was saved in
the file (xlt is a template file), so it carried over to any machine's Excel
that opened the file. Then moving the buttons to the standard bar was easy.
The marcors were in the personal.xls file which seemed to work in either
version of Excel.

sh

 

[Dave Peterson]

I thought that you used customized the toolbars via tools|Customize.

But if you're creating your own toolbar to run your own macros, you may find
building the toolbar when the workbook opens easier to use--and easier to share
with others.

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)

 

[sh]

I did customize thestadardtoolbar. But to stick it into a worksheet so I
could move it to another machine, I pulled the custom buttons to an
otherwise blank custom toolbar.

Trying to migrate the XLB file didn't work but this other method did. I jsut
pulled the buttons from the custom bar to the standard bar on the second
machine.