I actually triedActiveWorksheet.unprotect (I hadn't protected it with a password) butfor some reason it didn't work. Anyway, I now have it working withActiveSheet.Protect UserInterfaceOnly:=True