ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   how do i set conditional protection on cells in excel (https://www.excelbanter.com/excel-worksheet-functions/129715-how-do-i-set-conditional-protection-cells-excel.html)

Brian

how do i set conditional protection on cells in excel
 
I am trying to limit the cells another user can access on a sheet by the
condition in another cell.

In cell A1 input name
in cell B1 opt for single or attached from validation list
if attached is selected then
cell C1 is unprotected and input partner name
else cursor moves onto A2 as C1 is protected

Any thoughts ?




All times are GMT +1. The time now is 09:54 AM.

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