| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Private Sub - Only Accessible from same Module?
This is more a confirmation than a question....
If I have a Public Sub that calls on another Sub which is Private, if the Private Sub is not in the Module then an error appears. My question then is why doesn't excel2003 allow for cross-module Private Subs to be called upon? It seems to me like it makes sense to give a private sub it's only individual Module so that you can easily work on whichever sub you want to. What's the reason, if any, for this type of setup? Thanks, Neil |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Private Sub - Only Accessible from same Module?
What do want the word Private to mean instead?
If you want to call a sub from a different module, why not make the sub public? If you absolutely have to keep your private and you absolutely have to call it from a different module, then you could use application.run. pallaver wrote: This is more a confirmation than a question.... If I have a Public Sub that calls on another Sub which is Private, if the Private Sub is not in the Module then an error appears. My question then is why doesn't excel2003 allow for cross-module Private Subs to be called upon? It seems to me like it makes sense to give a private sub it's only individual Module so that you can easily work on whichever sub you want to. What's the reason, if any, for this type of setup? Thanks, Neil -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macros in Personal.xls Not Accessible | Excel Discussion (Misc queries) | |||
| CLASS MODULE & SIMPLE MODULE | Excel Discussion (Misc queries) | |||
| code in module A to not execute a Worksheet_SelectionChange sub of another module | Excel Discussion (Misc queries) | |||
| Private sub | New Users to Excel | |||
| The folder"name" isn't accessible | Excel Discussion (Misc queries) | |||
Hybrid Mode
