Making add-in available
 

You would need a function in the addin that displays the form and returns a
reference to it so your code in the other workbooks can manipulate it.

then you would run that function with
Dim frm as Object
set frm = Application.Run ( "MyAddin.xla!fShowForm")

--
Regards,
Tom Ogilvy


"mnt" wrote in message
...
I have an add-in that has a form and code. My goal is to have several
spreadsheets access this form an code without having to copy it to every
spreadsheet. The add-in is installed and the add-in is checked in Add_ins.

I get the form to appear and can't see the code. I'm not sure what I'm
missing.