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.


DKS wrote:

Hi,

Few days back I had posted a question on how can I "publish" an updated
custom toolbar to my friends and colleagues?

The reply I received was to write a VBA macro that would delete my custom
toolbars on file close. And then on file open the macro to add my new
updated custom toolbar.

The deleting of custom toolbar happens fine, but I am stuck at "adding" the
custom toolbar once it has been deleted.

A practical question that bothers me: if a toolbar is explicitly deleted
then how can I get .xls to add the toolbar the next time it is opened?

Can somebody help?

--

Dave Peterson