| 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 |
| 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) | |||
Threaded Mode
