| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sub () that does NOT appear in Macro selection
Is there a way to have a Sub () not appear in the macro selection (alt f9) ?
|
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Sub () that does NOT appear in Macro selection
Private Sub yourMacroNmae()
"J@Y" wrote: Is there a way to have a Sub () not appear in the macro selection (alt f9) ? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Sub () that does NOT appear in Macro selection
On Jul 13, 11:46 am, Mike wrote:
Private Sub yourMacroNmae() "J@Y" wrote: Is there a way to have a Sub () not appear in the macro selection (alt f9) ? If a sub has a parameter then it won't appear. private sub yourMacroName(dummy as object) Just pass in a 0 Peter |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Sub () that does NOT appear in Macro selection
I just noticed that Private subs from other modules can't be called. Is there
a way around this? " wrote: On Jul 13, 11:46 am, Mike wrote: Private Sub yourMacroNmae() "J@Y" wrote: Is there a way to have a Sub () not appear in the macro selection (alt f9) ? If a sub has a parameter then it won't appear. private sub yourMacroName(dummy as object) Just pass in a 0 Peter |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Sub () that does NOT appear in Macro selection
On Jul 13, 12:16 pm, J@Y wrote:
I just noticed that Private subs from other modules can't be called. Is there a way around this? " wrote: On Jul 13, 11:46 am, Mike wrote: Private Sub yourMacroNmae() "J@Y" wrote: Is there a way to have a Sub () not appear in the macro selection (alt f9) ? If a sub has a parameter then it won't appear. private sub yourMacroName(dummy as object) Just pass in a 0 Peter Don't put the word private on it. Peter |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Sub () that does NOT appear in Macro selection
Hi J@y, private subs are normally used for ThisWorkbook, Worksheet and
Control Event code such as Workbook_Open, Wordsheet_Activate and UserForm_Click. They are not intended to work except for that specific environment. If the designer wants code to be public and able to be called from anywhere in the project, then the code needs to be written in the general modules which are named Module 1, 2, etc. and do not precede the word sub with the word private. "J@Y" wrote: I just noticed that Private subs from other modules can't be called. Is there a way around this? " wrote: On Jul 13, 11:46 am, Mike wrote: Private Sub yourMacroNmae() "J@Y" wrote: Is there a way to have a Sub () not appear in the macro selection (alt f9) ? If a sub has a parameter then it won't appear. private sub yourMacroName(dummy as object) Just pass in a 0 Peter |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Sub () that does NOT appear in Macro selection
Quick and simple. Thanks!
"Mike" wrote: Private Sub yourMacroNmae() "J@Y" wrote: Is there a way to have a Sub () not appear in the macro selection (alt f9) ? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can run a macro ( call a macro) on selection of any filtercriteria? | Excel Worksheet Functions | |||
| SELECTION macro | Excel Discussion (Misc queries) | |||
| Copy Selection - Transpose Selection - Delete Selection | Excel Discussion (Misc queries) | |||
| Macro for row selection | Excel Discussion (Misc queries) | |||
| Macro to print selection | Excel Programming | |||
Hybrid Mode
