If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Variable validation-password protect sheet
I am using the Variable validation procedure(
DataValYesNoClear.xls) from: http://www.contextures.com/excelfiles.html in my workbook and it's working great. However, after applying a password to protect the sheet I noticed that the drop downs and validations would not work. Received the message that the cells were read only. Then I unprotected the sheet and changed the format of the cells to "unlocked" . I then protected the sheet and this time when I clicked on cell B3 got the "run time error 1004". When I went back and unprotected the sheet the drop downs in B3 where ok but C3 and D3 where not. Any ideas. Thanks and have a fun day. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How do I password protect an entire folder in Word or Excel? | Jam-Du | General Discussion | 1 | November 10th, 2004 06:06 PM |
Can I use a variable to select sheet reference? | Bob F. | General Discussion | 1 | September 2nd, 2004 10:37 PM |
Password Protect the Unhide Sheet Function | Paul B | Worksheet Functions | 0 | June 11th, 2004 08:15 PM |
Protect sheet option not highlighted to use | Dee | Worksheet Functions | 4 | October 2nd, 2003 04:24 PM |
Protect Sheet option not available | Dee | Worksheet Functions | 1 | October 2nd, 2003 03:05 PM |