How to call a private sub() in another module

[J@Y]

Is there a way to call a private sub from another module? I am trying to have
the private sub not visible in the Macro selection, but I can't call it from
another module by having it private.

 

[XP]

Hi,

I would put: Option Private Module
at the very top of your module, thus cloaking it from the macros menu;

Then make your sub public as in: Public Sub MySub()

HTH

 

[Mike]

Run "myMacroName"

 

[J@Y]

Thanks, thats something useful to know.

Hi,

I would put: Option Private Module
at the very top of your module, thus cloaking it from the macros menu;

Then make your sub public as in: Public Sub MySub()

HTH

 

[J@Y]

Genius!

Run "myMacroName"