macro for protection

[Guest]

I recorded a macro to protect a sheet and then then workbook - and I input a
password. The recorded macro protects both the sheet and workbook - but
doesnt use a password. Is there a syntax to use to protect them with a
password ?
This is my code for recording the macro.

Application.CutCopyMode = False
ActiveWorkbook.Protect Structure:=True, Windows:=False

Thanks,
Yosef

 

[Trevor Shuttleworth]

Yosef

lookup Protect in the VBA Help

ActiveSheet.Protect Password:=drowssap

ActiveWorkbook.Protect Password:=drowssap

ThisWorkbook.Protect Password:=drowssap

Regards

Trevor

 

[Guest]

Im not a programmer so the help was a bit too confusing for me.
Ill copy in your syntax and see what happens. I assume drowssap is your
actual password ?
Thanks

 

[Trevor Shuttleworth]

Needs to be in quotes if it is the actual password ... my omission. Unless
you have a variable called drowssap with your password in it.

Yes, I'm sure the help on this used to be more simple than it is now.

Regards

Trevor