ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Protect worsheet, but allow user to hide rows (https://www.excelbanter.com/excel-discussion-misc-queries/19086-protect-worsheet-but-allow-user-hide-rows.html)

SeattleSus

Protect worsheet, but allow user to hide rows
 
How do I protect a worksheet with some cells locked, but then still allow a
user to hide and uhide rows?

Dave Peterson

Maybe provide a macro that would unprotect the worksheet, hide the selected
rows, and then reprotect the worksheet????


SeattleSus wrote:

How do I protect a worksheet with some cells locked, but then still allow a
user to hide and uhide rows?


--

Dave Peterson


All times are GMT +1. The time now is 04:57 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com