Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
Also, using the Tab key to navigate within the sheet will take the user to
only the unlocked cells. "laurentdada" wrote: Once I have protected a sheet leaving unprotected cell to allow users chsnge or input data, users of this sheet do not know which cells they can change (unprotected) unless they try to click on every cell and are allowed to change the data in it. My question is: is there a way to display protected or unprotected sheet and if there is how to do it; and whether we can control the movement of the cursor in a protected sheet. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I get excel to add cells by color? Like all green cells (s. | Excel Discussion (Misc queries) | |||
UDF and Calculation tree | Links and Linking in Excel | |||
How do I password protect cells in a spreadsheet created in Excel | Excel Worksheet Functions | |||
How do I password protect cells in a spreadsheet created in Excel | Excel Worksheet Functions | |||
stop excel from shifting cells up when a query returns no data | Excel Worksheet Functions |