thanks much! i knew i had forgotten something simple. too much of staring at the trees in the forest, so to say
the reference fixed it all up, works like a charm

thanks again


----- Tom Ogilvy wrote: ----

On additional caution. You can't directly show a userform from you
workbook. You would need to call a macro in the addin that shows th
userform or that at least loads it and returns a reference to it

--
Regards
Tom Ogilv

"alfaista" wrote in messag
..
okay, this should be pretty darned simple, but it seems those are alway
the things that jump up and bite me
i've created a workbook that has 12 modules and 7 user forms. thi
workbook will be distrubuted to others, so obvioulsy the best thing to do i
to make all the code an add in and have some basic workbook and workshee
functions that call the add in code
i've gotten that far, and added code that successfully adds the add in a
the opening of the workbook. but then it says that it can not see any of m
add in module names
am i referencing them incorrectly? this has to be something that is ver
simple that i am just having a brain hiccup on....
i.e.
Private Sub Worksheet_Change(ByVal Target As Range
AddInWorksheet_Change Targe
End Su
where AddInWorksheet_Change is defined in the addin workbook as a publi
sub
Public Sub AddInWorksheet_Change(ByVal Target As Range
Dim sCellAddress As Strin
Dim rNew As Rang
Dim rOld As Rang
etc.....
thanks much
heid