Macro Problem?
 

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.

Macro Problem?
 

Check your "ThisWorkbook" code to ensure that there is not a "Workbook_Open"
event. You might also want to check the "Locked" status of the SOME cells in
question. (Right-click cell, Format Cell, Protection Tab) If the cell is
not locked (unchecked) it will not be protected.

Mike

"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.

Macro Problem?
 

Is the macro called Auto_Open? If so, rename it.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Roy" wrote in message
...
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.

Macro Problem?
 

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