Excel 2003 - VBA - toolbars

[C Brandt]

To-date, I have been supplying access to macros via a button on one or more
of the sheets. I would like to progress to using a toolbar with buttons and
dropdown menus.

Can anyone offer me a URL address to a good tutourial on the generation and
assembly of a toolbar?

Thanks,
Craig

 

[Jim Cone]

Craig,
Give this a try...
http://www.contextures.on.ca/xlToolbar02.html

or Bob Phillips has some code in this post...
http://tinyurl.com/22muje

or personally, I like the instructions in John Walkenbach's book,
"Excel 97 Programming for Windows for Dummies",
Chapter 19 - "Customizing the Excel Toolbars".

If you are using XL2007, good luck.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)


"C Brandt"
wrote in message
To-date, I have been supplying access to macros via a button on one or more
of the sheets. I would like to progress to using a toolbar with buttons and
dropdown menus.
Can anyone offer me a URL address to a good tutourial on the generation and
assembly of a toolbar?
Thanks,
Craig

 

[C Brandt]

Thanks Jim. This did the trick.