I have a few workbooks that create the toolbars on the fly when the workbook is
opened. And delete them when the workbook closes. If I allow macros to run,
then these toolbars will appear the Addin's tab in xl2007.

(I've never attached a toolbar to a workbook to see how that works in xl2007,
though. And I'm not sure how you created your toolbar.)

Saved from a previous post:

Your life will become much simpler if you include code to create the toolbar
when the workbook is opened and include code to destroy the toolbar when the
workbook is closed.

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)

In xl2007, those toolbars and menu modifications will show up under the addins.

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



John M wrote:

I've got an addin written a few years ago. Unfortunately it doesn't want to
work in Office 2007, due to the fact that there are no toolbars anymore. How
do I expose the Sub Procedures within the addin to a user, so they can
execute them, without using a toolbar?

Many thanks

--

Dave Peterson