Private Macros
 

When programming Macros in Excel, is there a way to make certain Macros
private (used by your routine but not able to be seen when pressing the
Macro button in Excel).

Thanks

Private Macros
 

hi,

just change
Sub Macro1()

by
Private Sub Macro1()

isabelle

Le 2013-11-12 18:27, JCO a écrit :
When programming Macros in Excel, is there a way to make certain Macros
private (used by your routine but not able to be seen when pressing the
Macro button in Excel).

Thanks

Private Macros
 

isabelle wrote:

Le 2013-11-12 18:27, JCO a écrit :
When programming Macros in Excel, is there a way to make certain Macros
private (used by your routine but not able to be seen when pressing the
Macro button in Excel).

Thanks

hi,

just change
Sub Macro1()

by
Private Sub Macro1()

Or require parameters:

Sub Macro1(whatever)

--
"Stupid goddamned robot," I muttered.

Private Macros
 

Thanks

"Auric__" wrote in message
.116...
isabelle wrote:

Le 2013-11-12 18:27, JCO a écrit :
When programming Macros in Excel, is there a way to make certain Macros
private (used by your routine but not able to be seen when pressing the
Macro button in Excel).

Thanks

hi,

just change
Sub Macro1()

by
Private Sub Macro1()

Or require parameters:

Sub Macro1(whatever)

--
"Stupid goddamned robot," I muttered.