Exporting a toolbar
 

Excel 2003

I've created a personal toolbar, which includes specific canned command
buttons, as well as about six "designer" buttons which I created to activate
several formatting macros.

I'd like to recreate this toolbars, along with the embedded macros, to a
different computer.

What is (are) the file(s) I should copy over, and in what folder(s) are
they?

--

PT

Exporting a toolbar
 

I think you'l have many fewer problems if you create the toolbar on the fly when
the workbook opens (and destroy that toolbar when the workbook closes).

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)

PT wrote:

Excel 2003

I've created a personal toolbar, which includes specific canned command
buttons, as well as about six "designer" buttons which I created to activate
several formatting macros.

I'd like to recreate this toolbars, along with the embedded macros, to a
different computer.

What is (are) the file(s) I should copy over, and in what folder(s) are
they?

--

PT

--

Dave Peterson