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"
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Protection 2
Protecting worksheet. 1
Controlling worksheet protection via VBA 0
How to bypass password when pasting FROM a protected workbook 3
Different password for different worksheet " Help !" 1
Unprotect, Run Action then Protect 2
Password protect worksheet 1
including macro in protected worksheet 2

Back
Top