ExcelBanter - Hidden rows

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Hidden rows (https://www.excelbanter.com/excel-programming/427680-hidden-rows.html)

Hamed parhizkar

Hidden rows

If I hide rows for instance rows 50-100 are hidden. If I then protect the
sheet, how can the end user of the locked sheet still be able to unhide these
lines?

Is it possibe to have a protected sheet but still hide and unhide lines?

dan dungan

Hidden rows

The only way I know is to unprotect the sheet first.

All times are GMT +1. The time now is 07:20 PM.