#1   Report Post  
Posted to microsoft.public.excel.programming
Sam Sam is offline
external usenet poster
 
Posts: 699
Default Macro Menu

I have a userform with command buttons that initiate procedures in general
modules. How can I prevent these procedures from being run via
Tools...Macro...Macros?
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 709
Default Macro Menu

Sam, put Option Private Module at the top and you want see any macros in the
module, or put Private in front of you sub it you only want to hide one or
two, like Private Sub Test
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Sam" wrote in message
...
I have a userform with command buttons that initiate procedures in general
modules. How can I prevent these procedures from being run via
Tools...Macro...Macros?



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
Old Menu Macro oldjay Setting up and Configuration of Excel 1 December 15th 09 08:06 PM
Macro in Menu Zainuddin Excel Discussion (Misc queries) 1 June 28th 09 11:21 AM
MACRO MENU REDANDY Excel Discussion (Misc queries) 5 October 26th 07 01:10 AM
Macro Drop Down Menu MCook Excel Discussion (Misc queries) 1 October 11th 07 09:12 PM
How to get a vba macro to show up in the macro menu JacksonRJones Excel Programming 3 May 12th 06 02:11 AM


All times are GMT +1. The time now is 02:10 PM.

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

About Us

"It's about Microsoft Excel"