Are you building a toolbar or adding something to the menubar?

If you are...

I think your life will be lots easier if you create that toolbar when the
workbook opens and destroy it when the workbook closes.

Some references if you want to look at that option:

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)

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

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


FJ wrote:

Hi, I'm very new to VBA and I'm trying to create an add-in. The problem is,
after I've created it, I can't seem to load it correctly so that the macros
will be available to other workbooks. I have read several pages of step by
step instructions online that are very good and very detailed, but in the
end, I still can't seem to get it to work. Ive done the following:

- Created the add-in.
- Renamed the VBAProject in the properties window.
- Saved the add-in in c:\documents and settings\John Doe\Application
Data\Microsoft\AddIns.
- Set the reference to the add-in from the Tools, References box in the VB
editor.
- Made sure the box is checked in Tools, Add-Ins on the Excel worksheet.

I'm probably missing something very obvious, but since VBA is all very new
to me, I'm not sure what.

Thanks in advance for any help or advice.

P.S., sorry if this is a duplicate post. I tried to post a while ago and
got an error message. Not sure if it went through twice.

--

Dave Peterson