Importing Custom Toolbars

[josh]

I recently created several custom toolbars to work with a particular
workbook. When I moved the Excel file which was that workbook to another
computer, I discovered that the toolbars were not associated with the
workbook and hence didn't exist on the other computer. Is there anyway to
transfer these toolbars short of recreating them.
Josh

 

[Chip Pearson]

Josh,

While the best practice is to dynamically create toolbars with
code, you can attach a toolbar to a workbook. Go to the View
menu, choose Toolbars, then Customize. In that dialog, click the
Toolbars tab, and then Attach. In the Attach dialog, select your
custom toolbar in the left pane and then click Attach.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[josh]

Thank you Chip, That's just what I needed to know.
Josh