CommandBars

[mark]

Hello.

If someone makes a custom commandbar, is there an easy way to save the
description of that commandbar out to the local computer or network, so that
that custom commandbar can then be imported into a computer's Excel setup?

Thanks,
Mark

 

[Dave Peterson]

I would do my best not to make the commandbar manually. Those changes are
included in a *.xlb file. And you can't split out the important icons from the
non-important icons when you want to merge them into another computer.

Instead, I try to all the work via code. Then I can just share a workbook (or
addin) with others. They can either install the addin (Tools|Addins) or they
can just load the file when they need the functionality.

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)

In xl2007, those toolbars and menu modifications will show up under the addins.

And if you use xl2007:

If you want to learn about modifying the ribbon, you can start at Ron de Bruin's
site:
http://www.rondebruin.nl/ribbon.htm
http://www.rondebruin.nl/qat.htm -- For macros for all workbooks (saved as an
addin)
or
http://www.rondebruin.nl/2007addin.htm