I want to create a custom toolbar that will open everytime I open Excel. It
will basically be shortcuts to commonly used formatting methods I use, such
as highlighting and changing font color, etc... I have created the macros for
these without a problem and have created a custom toolbar through the
"Customize" function under "Tools" in Excel on my computer to do this without
a problem. However, I want to be able to give this toolbar to others so they
can access it.

I have tried unsuccessfuly to create a toolbar in my personal.xls file that
can be copied and given to others. I can create the toolbar but can't figure
out how to create a button on the toolbar that is a drop down list/menu from
which the macro options can be selected.

How do I create the menu button on the toolbar and include options in the
menu for the different macros?

Thanks