In excel 2003 I can add a customized command to the top of the tool bar, but
when I close out of Excel, and re-open it goes away. Any Ideas?

Signature
Thanks!
Bernard Liengme - 19 Mar 2008 22:23 GMT
Home PC or on network?

Signature
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email
> In excel 2003 I can add a customized command to the top of the tool bar,
> but
> when I close out of Excel, and re-open it goes away. Any Ideas?
Dave Peterson - 19 Mar 2008 22:24 GMT
Customize your toolbar in code.
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)
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
In xl2007, those toolbars and menu modifications will show up under the addins.
> In excel 2003 I can add a customized command to the top of the tool bar, but
> when I close out of Excel, and re-open it goes away. Any Ideas?
> --
> Thanks!

Signature
Dave Peterson