Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
JCO JCO is offline
external usenet poster
 
Posts: 54
Default 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

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 587
Default 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

  #3   Report Post  
Posted to microsoft.public.excel.programming
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.
  #4   Report Post  
Posted to microsoft.public.excel.programming
JCO JCO is offline
external usenet poster
 
Posts: 54
Default 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.


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Improve method of calling a private function in a private module XP Excel Programming 1 April 30th 08 06:41 PM
How can I see/edit my Private macros i VB? Ace70 Excel Discussion (Misc queries) 1 June 13th 07 10:02 AM
Private - seeing macros again! Nick Smith[_2_] Excel Programming 4 April 27th 06 08:21 PM
re : Possible to run private sub macros by writing another private ddiicc Excel Programming 5 August 26th 05 04:49 AM
Private Sub Running Other Private Sub Inadvertently Ross Culver Excel Programming 2 February 10th 05 07:17 PM


All times are GMT +1. The time now is 03:07 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"