Protecting cells in multiple worksheets

[Alison_Gillon]

Hi

I am trying to 'allow edit ranges' (lock certain cells) in multiple worksheets, can anyone help?

I know how to do this on a single worksheet but would like to find a solution to do it across multiple worksheet in the one file.

Many Thanks

[#2]

Hello,

You can check the links below to guide you

https://docs.microsoft.com/en-us/office/troubleshoot/excel/apply-password-to-separate-range

https://www.mrexcel.com/board/threads/how-to-protect-and-unprotect-the-same-data-range-in-multiple-s...