#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default PROTECTING CELLS

I am having trouble protecting some cells. I mark all the required cells to
be locked, then apply the Protect to the spreadsheet. Some cells are locked
and some are not. What's up?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 48
Default PROTECTING CELLS

Hi there try this make sure the sheets to be protected are not selected but
only those that will not be protected and uncheck the locked cell box in
protection tab and then go and to review and protect your sheet you 'll be ok

"LOCKING CELLS" wrote:

I am having trouble protecting some cells. I mark all the required cells to
be locked, then apply the Protect to the spreadsheet. Some cells are locked
and some are not. What's up?

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 833
Default PROTECTING CELLS

EXCEL 2007

This may help you:-

Take the following actions assuming that the range that you wish to, "lock"
is D 83 to D 85.

1. Go into you Worksheet and click on cell to the left of column A and above
the number 1.

This should highlight the whole Worksheet.

2. Ctrl + 1 (at the same time) / Custom Lists pane should launch (sometimes
this window has a different name because there is a bug in the software here)
/ go to the Protection tab / remove the tick (check) from the Locked field
and hit OK.

3. Now go back to your Worksheet and highlight cells D83 to D 85 only / Ctrl
+ 1 again / Custom Lists should launch / go to Protection tab again and place
a tick (check) in the Locked field / OK.

4. Home tab / Cells group / Format / Protect Sheet / Protect Sheet window
should launch / put a password of your choice in / hit OK / put password in
again / OK.

5. Now to test that it has worked go back to cells D 83 to D 85.

If you try to enter info into any of those 3 cells you will not be able to
but you will be able to see the formulas there.

6. You should be able to enter data into all other cells in the Worksheet.

If my comments have helped please hit Yes.

Thanks.



"LOCKING CELLS" wrote:

I am having trouble protecting some cells. I mark all the required cells to
be locked, then apply the Protect to the spreadsheet. Some cells are locked
and some are not. What's up?

Reply
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
Protecting Cells J4shaw Excel Discussion (Misc queries) 1 August 21st 09 11:57 AM
protecting the cells David Biddulph[_2_] Excel Discussion (Misc queries) 0 August 21st 08 11:04 AM
Protecting Cells Pedro Excel Discussion (Misc queries) 2 June 8th 06 06:25 PM
Protecting cells GregP1962 Excel Discussion (Misc queries) 2 June 7th 06 10:55 PM
Protecting Cells Katie Excel Worksheet Functions 0 September 16th 05 03:36 PM


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

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

About Us

"It's about Microsoft Excel"