Worksheet change Event

R

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
 
G

Gord Dibben

See the responses at your other post in programming group.


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

events 3
How do I set focus (and select text) on a text box on a modeless userform? 0
VBA word change keys 0
Countdown macro - display settings 2
Insert/ delete row in protected worksheet 6
Code to format cells on several worksheets 2
Spell Checking on a protected sheet 3
Spell Check Protected WORKBOOK 1

Top