I've added two named ranges - Bob & Claire.
The code unlocks the selected range if the password is correct. Selecting a cell out of that range relocks the cells
look at the code for the passwords.
I've added two named ranges - Bob & Claire.
The code unlocks the selected range if the password is correct. Selecting a cell out of that range relocks the cells
look at the code for the passwords.
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
Thank you very much, but is the password secret, because I cant seem to get it to work.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks