how to hide a macro name from macro listings

[Guest]

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
?

 

[Bob Phillips]

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)

 

[Guest]

That is great. Thanks

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)