View Single Post
  #1   Report Post  
ynissel
 
Posts: n/a
Default macro for protection

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 Structu=True, Windows:=False

Thanks,
Yosef