Reference Addin Module from sheet code
Hi zSplash,
This is the syntax
Application.Run ("MyAddin.xla!MySub")
--
HTH
Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
"zSplash" wrote in message
...
I try to reference MyAddin.MyModule.MySub from another worksheet, which
has
references to MyAddin, but as I step through the code, it simply "passes"
the code without running MySub (although the intellisense helps me spell
out
entire reference). Do I need a "!" or something? Puzzling to me, since
it
often works, in other cases.
TIA
|