Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Protection unlocked cells
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to change format protection default to unlocked? | Excel Discussion (Misc queries) | |||
Why is AutoSum iinoperable w/protection when column is unlocked? | Excel Worksheet Functions | |||
paste locked cells and unlocked cells in protected sheet | Excel Worksheet Functions | |||
Moving from unlocked cells to unlocked cells in an excel form | Excel Worksheet Functions | |||
Password Protection - Select Unlocked Cells Only | Excel Programming |