Protecting cells in multiple worksheets

Question

Hi&nbsp;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.&nbsp;Many Thanks&nbsp;

abiola1 · Answer

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-sheets-and-modify-this-range-each-month-excel-2010.686486/

Forum Discussion

Protecting cells in multiple worksheets

1 Reply