Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Locking cells after the user has entered values in protected works
Hi,
I am trying to write a macro that asks a user if they are sure they have entered the right data, when they answer yes, I want the macro to lock cells in another spreadsheet. This spreadsheet is password protected, so the user can only enter data into the cells I now wish to lock. The password example I give here is ABC. I have written the following code, but get errors. Sub LockValues() ' Lock the values entered in cells D6 to D23 in Worksheet 1 If MsgBox("Are you sure your entries are " _ & "correct and complete?", vbYesNo) = vbYes _ Then Sheets("Worksheet 1").Select ActiveSheet.Unprotect Password:="ABC" Range("D6:D23").Select Selection.Locked = True ActiveSheet.Protect "ABC" End Sub Can someone advise me what changes I should make? Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Locking Cells when user inputs data | Excel Discussion (Misc queries) | |||
creating a macro where the values entered in a text box on a user | Excel Programming | |||
Macro for locking cells after worksheet is protected | Excel Programming | |||
How do I just update values on several cells (not the entire works | Excel Programming | |||
Locking other cells based on values in a cell. | Excel Programming |