ADD IN help
 

Hi,
I have developed a vba app that worked fine but I have now changed i
to an addin and having a couple of problems.

When the addin menu is loaded, it contains an option to load a templat
worksheet to work from, the work sheet contain 25 combo boxes and I hav
an init() sub that connects each combo to a class module to detec
certain events, this all loads correctly and functions as it i
supposed to. The inint function is called when the worksheet is copie
from the addin to the active worksheet.

The problem I am having is if the user decides to save this templat
sheet and re opens it, then the init sub is not called. I have trie
making this calll in the auto open but as there are no sheets open a
the time it throws back an error. Where is the best place to call th
init sub without making the user select a menu item to call this sub?
have tried the worksheet activate event but with no joy, as soon as th
sheet is loaded I need to make the sub init call but cannot think ho
or where to do this, any ideas?

Thank yo

--
cmpcwil
-----------------------------------------------------------------------
cmpcwil2's Profile: http://www.excelforum.com/member.php...fo&userid=3341
View this thread: http://www.excelforum.com/showthread.php?threadid=55362