Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
CommandBars
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
CommandBars
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 mark wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
CommandBars vs CommandBars(1).Controls | Excel Programming | |||
help --- Commandbars | Excel Programming | |||
Commandbars | Excel Programming | |||
CommandBars | Excel Programming |