Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Inserting comment in unlocked cell in protected sheet
I am un-protecting the worksheet, adding a new column for data. The cells in
the new column are unprotected and I would like to allow for the insertion of comments after re-protecting the worksheet. Code 1 (with blank for password) works but Code 2 (with password "PW Code") causes error in line 5. What is correct syntax for Code 2 Line 5? Any help would be appreciated. Thanks in advance. €˜Code 1 Leaving Password Blank 1 Sheets("Sheet1").Select 2 ActiveSheet.Unprotect 3 Worksheets("Sheet1").Columns("D:D").Select 4 Selection.Insert Shift:=xlToRight 5 ActiveSheet.Protect DrawingObjects:=False €˜Code 2 Using password €œPW Code€ 1 Sheets("Sheet1").Select 2 ActiveSheet.Unprotect ("PW Code") 3 Worksheets("Sheet1").Columns("D:D").Select 4 Selection.Insert Shift:=xlToRight 5 ActiveSheet.Protect ("PW Code") DrawingObjects:=False |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Inserting comment in unlocked cell of protected Excel worksheet? | Excel Worksheet Functions | |||
Changing Font in an unlocked cell in a protected sheet. | Excel Discussion (Misc queries) | |||
Inserting a Comment in a Protected Sheet? | Excel Discussion (Misc queries) | |||
How do I create a comment on an unlocked cell in a protected sheet | Excel Discussion (Misc queries) | |||
How do I insert a comment in unlocked cell of a protected workshee | Excel Worksheet Functions |