Worksheet protect/unprotect

[Guest]

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

 

[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'?

 

[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
----------------------------------------------------------------------------

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.