Ann_BBO
11-10-2009, 05:35 AM
Hi All,
How to protect the worksheet except a specific column. (e.g. Column I)
Sub Protect()
Columns("I:I").Select
ActiveSheet.Protect Password:="abc"
ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True
End Sub
Here is my code but it is protect all sheet.
Thanks,
Ann
How to protect the worksheet except a specific column. (e.g. Column I)
Sub Protect()
Columns("I:I").Select
ActiveSheet.Protect Password:="abc"
ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True
End Sub
Here is my code but it is protect all sheet.
Thanks,
Ann