How to call a private sub() in another module

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
Thanks, thats something useful to know.

XP said:
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
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Outlook Private Sub Application_Startup()....What if it be public 1
How to call module function or sub from the Add In? 3
Calling Private Sub from User Form 4
Program Question for Dave peterson 2
No data from another macro in another module 2
Application.Ontime for Private Sub(Proceedure) - ThisWorkbook* 2
Auto_Open over Private Sub Workbook_Open() 2
Calling subroutine defined in another workbook (autostart workbook) 5

Back
Top