Forum Discussion
Alison_Gillon
May 20, 2020Copper Contributor
Protecting cells in multiple worksheets
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 ...
Abiola1
May 20, 2020MVP
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/
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/