In an Excel 2010 worksheet, we need the user to have to enter a password in order to allow entering content into unlocked cells (but not into locked cells). The Password Protect feature in Excel 2010 doesn't seem to work that way. It requires a password to remove password protection, but allows people to access unlocked cells without entering a password. How can we require a user to enter a password in order to access unlocked cells?
From the way I understand it you can't.
Locked is locked, can't use those cells, and unlocked is open to all.
HTH
Regards, Jeff
You could try to work around my code that uses BeforeDoubleClick. In following example initially the cells must be all protected and the sheet protected with pwd: 1234. The cells which may be edited are B3:C4.
An issue is that the password for the cells is the same for the sheet and that the last cell changed will not be blocked when finished.
You could add this code to block all cells when finished editing a cell:
Please Login or Register to view this content.
Please Login or Register to view this content.
Last edited by rollis13; 11-26-2012 at 07:34 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks