ExcelBanter - auto load personal command bar

I provided some code in here that will produce a programmed toolbar... If
you search for "GB Toolbar" (minus the quotes) you should find at least one
instance of a thread that has like 18 or more messages. Basically through
the conversations of helping someone else, you should see the ability to do
what you want... My code produces an entirely new toolbar, but... You could
incorporate something similar to get just your one button. If you put the
code that I provided in a module called toolbars then it will work as
written, and you can go through and find the information you need to
programmatically create the button you want... Ie. all of the bells and
whistles that you probably have already done on your own.

My code creates a commandbar that is free wheeling (i.e. is not docked at
the top, bottom, or sides.) It can be docked by the user, or you could force
it to be by changing the msoPosition portion.

Give it a shot, there should be plenty of discussion there to help you out.
:) Just might take a little bit to get through all of the messages. :)

"jenn" wrote:

I loaded a special style format button. I have to manually merge from
personal to the sheet I am working in when I first use the button in a new
workbook. Is there a way to get the personal command bar styles associated
with my command button to copy to all new worksheets? My macros are always
available that I have in my personal.