Thread: Private Macros
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Auric__ Auric__ is offline
external usenet poster
 
Posts: 538
Default 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.