Apologies for starting a new thread, just wondered if anyone had found a way round this: -
ThisWorkbook.Protect Structure:=True, Windows:=False
ThisWorkbook.ProtectSharing sharingpassword:="bobbins"
Doesn't work and gives an invalid procedure call. Removing the first line does work...
ThisWorkbook.Protect Structure:=True, Windows:=False
ThisWorkbook.ProtectSharing sharingpassword:="bobbins"
Doesn't work and gives an invalid procedure call. Removing the first line does work...