Worksheet protect/unprotect

C

Chris

I have a complicated worksheet that is to be used as a form. I did not want others to change the information in some of the cells, but they need to put information in others. So I locked those to not let them change and left the other unlocked. Then I protected the worksheet. Now, I cannot un-protect the worksheet for more than one edit. If I want to make a second edit, I have to re-unprotect the worksheet. This is true for both locked and unlocked cells

Any ideas of what I might have done wrong
 
F

Frank Kabel

Hi Chris
not sure what you issue is. What do you mean with 'I cannot un-protect
the worksheet for more than one edit'?
 
K

Ken Wright

At a guess that sounds like you could have an event macro that protects the
sheet, tied to a change event - Could that be the case?

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :)
----------------------------------------------------------------------------



Chris said:
I have a complicated worksheet that is to be used as a form. I did not want
Click to expand...
others to change the information in some of the cells, but they need to put
information in others. So I locked those to not let them change and left the
other unlocked. Then I protected the worksheet. Now, I cannot un-protect the
worksheet for more than one edit. If I want to make a second edit, I have to
re-unprotect the worksheet. This is true for both locked and unlocked cells.
 
Top