LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
princejohnpaulfin
 
Posts: n/a
Default how do you "select locked cells" w/o "select unlocked cells"?

I am using Excel 2003.
I am attempting to protect only certain cells within an Excel worksheet. I
first click on FORMAT, CELLS, and "deselect" the "LOCKED" check box. I then
highlight the cells I wish to protect, repeat that step, only this time make
sure the LOCKED check box is checked.
I then go to to TOOLS, PROTECTION, PROTECT SHEET, and attempt to select the
option, and JUST the option for "Select locked cells", however, everytime I
select this option, a checkmark appears next to "Select unlocked cells" as
well. One seems to trigger the other. The net effect is that the WHOLE
worksheet becomes locked instead of just the protected cells.
Has anyone else experienced this problem and/or know of a solution?

Thankyou
 
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
In excel can you select certain cells which contain the same text ade Excel Discussion (Misc queries) 1 May 14th 05 02:49 PM
Viewing LOCKED cells AC_VID Excel Discussion (Misc queries) 1 April 9th 05 11:19 PM
How do I select a range if one cells contents is equal to another KHarrison Excel Discussion (Misc queries) 2 December 20th 04 09:35 PM
how can i select all the cells with same color on a sheet if there are multipale colors by vba code uobt Charts and Charting in Excel 1 December 15th 04 05:27 PM
Protected cells -automatically format to a different color Fred Evans Excel Discussion (Misc queries) 9 December 3rd 04 12:59 PM


All times are GMT +1. The time now is 02:34 PM.

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"