Workbook protection

[claudehollett]

I need the code to insert in the Before Close event to apply protection that can only be opened with a password. Lets say the password I want is "bill". Thanks so much. Claude

 

[shades]

    ActiveWorkbook.Protect Password:="bill", Structure:=True, Windows:=False