Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 108
Default Running macros

Is there a way to prevent running a macro through the Tools menu choice?
Thanks!
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default Running macros

Sub MyMacro(optional dummy = 1)

or

Private Sub MyMacro()

The macro can still be run through the tools menu choice, but won't be
listed.

--
Regards,
Tom Ogilvy


"cottage6" wrote in message
...
Is there a way to prevent running a macro through the Tools menu choice?
Thanks!



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
Running Macros Links and Linking in Excel 3 July 13th 06 11:30 PM
running macros from IF CJ Excel Worksheet Functions 2 April 30th 06 05:03 PM
running macros Jay Excel Discussion (Misc queries) 2 April 29th 05 12:56 AM
Running Macros simpleS Setting up and Configuration of Excel 1 February 17th 05 02:32 PM
Running Win Macros on Mac wammer[_2_] Excel Programming 4 August 7th 04 06:29 AM


All times are GMT +1. The time now is 09:30 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"