Hi,, I have a worksheet, that has some rows/cells locked and others that are unlocked so users can enter data in these. I'd like to allow users to be able to insert rows only in the unlocked range. Is this possilbe? Thanks a lot!
insert rows in protected sheet??
-
-
-
It depends partly on which version you (and they) have.
In XP you can specify what the user can do, including inserting rows.
-
Sorry,, we are running office 97.
-
Depending on how they enter the data, you could designa UserForm, and then when they enter the data, it would trigger a macro which would unprotect the sheet, insert the row(s), and then re-protect the sheet.
-
ok,, that sounds easy, so i tried it and it seemed to be working,, but the next time i tried it, it asked for the password to unprotect. is there a way to unprotect it, insert rows, reprotect, using a macro and not have to give the user the password? Thanks!!
-
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!