| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to call a private sub() in another module
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to call a private sub() in another module
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" wrote: 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. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to call a private sub() in another module
Run "myMacroName"
"J@Y" wrote: 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. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to call a private sub() in another module
Thanks, thats something useful to know.
"XP" wrote: 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" wrote: 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. |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to call a private sub() in another module
Genius!
"Mike" wrote: Run "myMacroName" "J@Y" wrote: 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Private Sub - Only Accessible from same Module? | Excel Discussion (Misc queries) | |||
| IF Statements-call private sub | Excel Worksheet Functions | |||
| Option Private Module | Excel Programming | |||
| private variable: same module, other Sub/Function | Excel Programming | |||
| Call Private Function from ThisWorkbook module | Excel Programming | |||
Linear Mode
