Protect all sheets without using a password

[SallyPoyzer]

Hi

Hopefully this is an easy one! Would someone be able to tell me the code I would need to protect all the worksheets in a workbook WITHOUT having to enter a password? All the codes I can find include a password or are just for protecting a single sheet. I don't want to have to enter a password every time I unprotect the worksheets, as the protection is there just to prevent staff accidentally changing a formula. If they deliberately want to change a password, that's fine.

Thanks

Sally

[aarona]

this will do

Please Login or Register  to view this content.

[SallyPoyzer]

Thank you for such a quick reply! That worked perfectly!