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
?

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
?

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
?