| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to hide a macro name from macro listings
I wrote two functions to unprotect and protectsheet for developmental usage.
I don't want to expose these macros to get exosed to the user when he/she hits on run macros. Is there any way to hide the macro invisible2 ? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
how to hide a macro name from macro listings
Yes, add Option Private Module at the head of the module containing the
macros. -- HTH Bob Phillips (remove xxx from email address if mailing direct) "MVM" wrote in message ... I wrote two functions to unprotect and protectsheet for developmental usage. I don't want to expose these macros to get exosed to the user when he/she hits on run macros. Is there any way to hide the macro invisible2 ? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
how to hide a macro name from macro listings
That is great. Thanks
"Bob Phillips" wrote: Yes, add Option Private Module at the head of the module containing the macros. -- HTH Bob Phillips (remove xxx from email address if mailing direct) "MVM" wrote in message ... I wrote two functions to unprotect and protectsheet for developmental usage. I don't want to expose these macros to get exosed to the user when he/she hits on run macros. Is there any way to hide the macro invisible2 ? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| macro to hide row with 0.00 | Excel Worksheet Functions | |||
| Hide Macro | Excel Programming | |||
| hide macro | Excel Programming | |||
| Hide row macro | Excel Programming | |||
| more help with a hide macro | Excel Programming | |||
Hybrid Mode
