Reference Addin Module from sheet code
 

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

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

Reference Addin Module from sheet code
 

Thanks, Bob.

st.

"Bob Phillips" wrote in message
...
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