A add-in will close when you close Excel.

Can you explain more what you want ?
Do you have problems when people use your menu with no workbook open ?



--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"LuisE" wrote in message ...
Thanks Ron, merry Christmas by the way.

Yes I did.
My concern is that the Add-In will remain installed even if not workbook in
opened so I'd imagine that it is technically not closed, is it?



"Ron de Bruin" wrote:

Do you create the menu with VBA code ?

You can create the menu in the Open even and close it in the beforeclose event
See this example

Debra Dalgleish's (Toolbar example from Dave Peterson)
http://www.contextures.com/xlToolbar02.html


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"LuisE" wrote in message ...
I have a menu from an Add-In, when all workbooks are closed and all the other
menus are disabled mine remains enabled.
How can I disabled it so if someone clicks it no error message is generated?
Just as the built-in ones.

Thanks in advance