how to set password to protect worksheet under excel?

  • Thread starter Thread starter shirley
  • Start date Start date
S

shirley

i want to protect my worksheet with password after a new row has bee
added in. how do i go about doing it? i am unsure what object o
methods to use
 
This is one of those things that you can solve by recording a macro:

I got this line:

ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True

xl didn't record the actual password. But I could look at help and see that I
need something like:

ActiveSheet.Protect DrawingObjects:=True, _
Contents:=True, Scenarios:=True, password:="hi"
 
Back
Top