You have a couple followup suggestions at your other post.

Roy wrote:

I copied some macros from this website to protect and unprotect sheets. It
appears as if the unprotect macro runs as soon as I open the file so SOME of
the cells that were protected are now unprotected. Both of these macros are
in Module1. How do I make the macros run only when I tell them to?

Thanks in advance for your help.

--

Dave Peterson