Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
problem in protecting excel worksheet
Hi,
What I want to happen is to allow selection of cells from range A11 to EU65536 only. So, i tried to unlock the cell protection for ranges "A11:EU65536" (by unchecking the Locked checkbox in the Format Cells Protection); and then protect the worksheet and choosing only the "select unlocked cells only" (i unchecked the 'select locked cells'). After I did that, I cannot navigate through the cells anymore using the arrow keys even if the current cell is inside the unlocked ranges of cells. Does anyone know a reason or a work-around regarding this? I am using windows 2000 and ms excel 2003 professional edition. I appreciate your help, thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 Protecting a worksheet. | Excel Discussion (Misc queries) | |||
protecting several parts of a worksheet in Excel 2007 | Excel Discussion (Misc queries) | |||
Password Protecting an Excel file problem | Excel Discussion (Misc queries) | |||
Protecting an Excel worksheet without locking the embedded scrollbar | Excel Discussion (Misc queries) | |||
Macro problem with protecting worksheet........... | Excel Programming |