Forum Discussion
erlacour
Apr 03, 2023Copper Contributor
EXCEL - Protection of cells
I want to protect my cells but also to be able to hide some row if they are empty. I'm able to protect my cells, but I don't know if is it possible (and how) to hide some rows if those cells are pro...
- Apr 03, 2023
When you protect the sheet, tick the check box 'Format Columns'. You will then be able to hide and unhide rows on the protected sheet.
HansVogelaar
Apr 03, 2023MVP
When you protect the sheet, tick the check box 'Format Columns'. You will then be able to hide and unhide rows on the protected sheet.
- erlacourApr 03, 2023Copper Contributor
HansVogelaar Thank you very much. That's exactly what I wanted to do.