ExcelBanter - Worksheet change Event

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Worksheet change Event (https://www.excelbanter.com/excel-worksheet-functions/173466-worksheet-change-event.html)

Worksheet change Event

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 a

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

Worksheet change Event

See the responses at your other post in programming group.

Gord Dibben MS Excel MVP

On Thu, 17 Jan 2008 07:45:02 -0800, ranswert
wrote:

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 a

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