LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,814
Default Locked Property off, but cannot select cell

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Locked Several Worksheets, allow format cells/select unlocked cell Ana24 Excel Discussion (Misc queries) 2 September 26th 09 01:15 AM
Locked worksheet & hyperlinks (w/ select locked cells unchecked) dgold82 Excel Discussion (Misc queries) 1 July 10th 09 09:42 PM
Up down arrow keys do not select cells if select locked cells unch roandrob Excel Discussion (Misc queries) 3 May 18th 09 12:48 AM
Locked property when pasting from a different session of Excel Illya Teideman Excel Discussion (Misc queries) 0 February 6th 08 06:14 PM
Select locked cells Ken G. Excel Discussion (Misc queries) 2 June 22nd 07 05:49 AM


All times are GMT +1. The time now is 01:09 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"