S
Steve
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
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