Exporting a toolbar

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

PT - 26 Jul 2006 23:01 GMT

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?

Signature

Reply to this Message

Dave Peterson - 26 Jul 2006 23:09 GMT

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)

> Excel 2003
>
[quoted text clipped - 11 lines]
>
> PT

Signature

Dave Peterson

Reply to this Message

Rate this thread: