Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have a worksheet that is protected but certain cells are not locked so
users can edit them, but I cannot select these cells. I can navigate to them by typing in the cell address in the toolbar, but I cannot select the cell with my mouse. The protection is set to allow the user to select both locked and unlocked cells. Even if I unprotect the sheet, I cannot select the cells, but as I said, I can navigate by typing in the cell address in the toolbar and edit the cells like normal. The only problem is selecting cells with the mouse. Any ideas what could be preventing me from selecting a cell with my mouse even though the cell is not protected? I am using Excel 2007. I am sure it's something simple I am overlooking. Steve |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Locked Several Worksheets, allow format cells/select unlocked cell | Excel Discussion (Misc queries) | |||
Locked worksheet & hyperlinks (w/ select locked cells unchecked) | Excel Discussion (Misc queries) | |||
Up down arrow keys do not select cells if select locked cells unch | Excel Discussion (Misc queries) | |||
Locked property when pasting from a different session of Excel | Excel Discussion (Misc queries) | |||
Select locked cells | Excel Discussion (Misc queries) |