Workbook Protect set options in VBA

[cadence]

Hey all

simple macro to protect a workbook, I'm just getting stuck on determining syntax so you can specifiy if the windows and structure options?

Sub Macro1()

ActiveWorkbook.Protect ("password")
With ActiveWorkbook
'.Structure:=True, Windows:=False '**** this part I'm stuck

End Sub

thanks

 

[Simon Lloyd]

Try this:

ActiveWorkbook.Protect Password:="password", Structure:=True, Windows:=True