ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Protection unlocked cells (https://www.excelbanter.com/excel-programming/309605-protection-unlocked-cells.html)

mangesh_yadav[_113_]

Protection unlocked cells
 
Hi,

I have a protected sheet. Now for the input cells, I could either us
the "Locked=False" feature or "Allow users to edit ranges" feature. I
there any particular difference between the two methods, or advantag
of one over the other.

- Manges

--
Message posted from http://www.ExcelForum.com


Jack Schitt

Protection unlocked cells
 
You might use the "Allow users to edit ranges" feature if you want to
password protect particular ranges in the workbook or selectively grant
access to particular ranges depending on who accesses the workbook. The
locked/unlocked cell format applies to all.

--
Return email address is not as DEEP as it appears
"mangesh_yadav " wrote in
message ...
Hi,

I have a protected sheet. Now for the input cells, I could either use
the "Locked=False" feature or "Allow users to edit ranges" feature. Is
there any particular difference between the two methods, or advantage
of one over the other.

- Mangesh


---
Message posted from http://www.ExcelForum.com/




mangesh_yadav[_117_]

Protection unlocked cells
 
Thanks

Manges

--
Message posted from http://www.ExcelForum.com



All times are GMT +1. The time now is 02:20 AM.

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