Worksheet change Event

[ranswert]

I have 2 questions:
when I run a change event procedure on the worksheet, I need to unprotect
the sheet and protect is once it is done. I have procedures to do that.
They are:

Sub protectsheet()
ActiveSheet.Protect
End Sub
Sub unprotectsheet()
ActiveSheet.Unprotect
End Sub

I call them in my change event code for the worksheet. After it ran, the
change event wouldn't work. How do I unprotect the sheet and protect it
again once the procedure is done?

My other question is
Once the change event stopped working I couldn't get it to work again. Even
when I removed all the code and did a simple msgbox(""). How do I fix this?

th

 

[Gord Dibben]

See the responses at your other post in programming group.


Gord Dibben MS Excel MVP