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)

surfbored wrote:

I've tried several ways to create and associate a toolbar button with a VBA
macro in Excel.

I'm not completely happy with any of the solutions I've come up with and
would like to know if anyone else out there would like to share their
favorite way of doing this?

The development can be as complex as is necessary.

The trick is that the resulting solution must be simple to implement but
still sturdy enough to hold up against users that can be too "creative".
Suggestions are most appreciated!

Thanks,

SB

--

Dave Peterson