Private Macros

[JCO]

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

 

[isabelle]

hi,

just change
Sub Macro1()

by
Private Sub Macro1()

isabelle

Le 2013-11-12 18:27, JCO a écrit :

 

[Auric__]

Le 2013-11-12 18:27, JCO a écrit :

hi,

just change
Sub Macro1()

by
Private Sub Macro1()

Or require parameters:

Sub Macro1(whatever)

 

[JCO]

Thanks

Or require parameters:

Sub Macro1(whatever)