Locked Property off, but cannot select cell

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
 
S

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.
 
D

Dave Peterson

Thanks for posting back with your solution.

Maybe it'll help someone else.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top