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

I figured out the problem. I set the scroll area on the Workbook open event.
I didn't realize by setting the scrollarea that I would restrict the ability
to even select a cell outside the scrollarea. I have some code to allow the
scrollarea to be adjusted to allowe users do the editing thy need to do.

"Steve" wrote:

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

Thanks for posting back with your solution.

Maybe it'll help someone else.

Steve wrote:

I figured out the problem. I set the scroll area on the Workbook open event.
I didn't realize by setting the scrollarea that I would restrict the ability
to even select a cell outside the scrollarea. I have some code to allow the
scrollarea to be adjusted to allowe users do the editing thy need to do.

"Steve" wrote:

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

--

Dave Peterson

This totally helped!!!!!!!!!!! Thanks!