Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hiding macros
Hello
I would like to hide my macros from being selected in the form Tools, Macro, Macro (alt + F8). If I make them private I can't call the prodcedures unless they are in the same module. I have several procedures I wish to call from varios Userforms. Is there anyway to make the procedures available to more than one userform but not available via alt + F8? Now I need the make copies of the procedures and if I need to make any changes I must do them in several modules. Is there any way to get around this? Thanks in advance. Torbjörn |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hiding macros
Torbjorn,
Put "Option Private Module" at the top of the code module. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Torbjörn Steijer" wrote in message ... Hello I would like to hide my macros from being selected in the form Tools, Macro, Macro (alt + F8). If I make them private I can't call the prodcedures unless they are in the same module. I have several procedures I wish to call from varios Userforms. Is there anyway to make the procedures available to more than one userform but not available via alt + F8? Now I need the make copies of the procedures and if I need to make any changes I must do them in several modules. Is there any way to get around this? Thanks in advance. Torbjörn |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hiding macros
Another way to keep your macros from showing up in Tools,
Macro, Macro is to add arguments to your Sub or Function procedures. That way, they can only be called from another procedure. For example: Sub MySub(strSomeString as string) can only be called in code with a variable like this: MySub strSomeString:="Now" -----Original Message----- Hello I would like to hide my macros from being selected in the form Tools, Macro, Macro (alt + F8). If I make them private I can't call the prodcedures unless they are in the same module. I have several procedures I wish to call from varios Userforms. Is there anyway to make the procedures available to more than one userform but not available via alt + F8? Now I need the make copies of the procedures and if I need to make any changes I must do them in several modules. Is there any way to get around this? Thanks in advance. Torbjörn . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hiding Macros | Excel Discussion (Misc queries) | |||
Hiding Macros | Excel Discussion (Misc queries) |