I'm using the following VBA-code to protect a row.
But I have a problem, if I lock row 18 it works perfect.
Please Login or Register to view this content.
Then I want to lock row 19, which works perfect to.
But row 18 unlocks at the moment I lock 19.
I want to be able to lock ~15 rows seperate from eachother.
Does anyone know a solution?
Kind regards,
GCDDS
Could it perhaps be easier to work with checkboxes and a submit button?
I'm no VBA-specialist (as you may have noticed)
Maybe I can explain my problem a little clearer;
I have a time registration sheet, a manager has to check the times that are filled in.
If the row is correct, it should be locked so that employees can't change anything in it no more.
I've created a hidden row (which is visible when the sheet is unprotected) where you have to put a 1 in it,
Then it locks that particular row.
But I can't lock more than 1 row with the VBA-code above.
Last edited by GCDDS; 12-21-2010 at 04:58 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks