Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Corey.....certain cell protection.....
Corey.....a few weeks back you helped me try to stop certain cells from
being protected...............Dec 12th 2006 13.09 I can't quite get it to work......................... Ive got a large-ish sheet open but only want to allow certain cells to be able to be alterred............ I seem to be able to either block the whole sheet or else it allows every cell to be over written... Dave :) |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Corey.....certain cell protection.....
CWith Unprotected sheet.
Click on the Small Grey Box Above the 1 and to the Left of the A. This selected ALL cells. IF you WANT MORE CELLS LOCKED than UNLOCKED , Then Format Cells Protection Tick the LOCKED. (UNTICK if MORE are to be UNLOCKED) Then Proceed to Select (ALT+ Cell's) all the cells you want UNLOCKED. Then WHILE cells are Highlighted : Format Cells Protection UNTICK the LOCKED Checkbox When you Protect sheet (IE. Tools Protection Protet Sheet) Tick or Untick what you want to do. (IE Allow Locked Cell to be Protected or NOT) See how ya go.... Corey... Then "DB" wrote in message .uk... Corey.....a few weeks back you helped me try to stop certain cells from being protected...............Dec 12th 2006 13.09 I can't quite get it to work......................... Ive got a large-ish sheet open but only want to allow certain cells to be able to be alterred............ I seem to be able to either block the whole sheet or else it allows every cell to be over written... Dave :) |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Corey.....certain cell protection.....
Nope still not working....can I email you the sheet
All I want to lock is yellowed.. Cheers Dave :))) "Corey" wrote in message ... CWith Unprotected sheet. Click on the Small Grey Box Above the 1 and to the Left of the A. This selected ALL cells. IF you WANT MORE CELLS LOCKED than UNLOCKED , Then Format Cells Protection Tick the LOCKED. (UNTICK if MORE are to be UNLOCKED) Then Proceed to Select (ALT+ Cell's) all the cells you want UNLOCKED. Then WHILE cells are Highlighted : Format Cells Protection UNTICK the LOCKED Checkbox When you Protect sheet (IE. Tools Protection Protet Sheet) Tick or Untick what you want to do. (IE Allow Locked Cell to be Protected or NOT) See how ya go.... Corey... Then "DB" wrote in message .uk... Corey.....a few weeks back you helped me try to stop certain cells from being protected...............Dec 12th 2006 13.09 I can't quite get it to work......................... Ive got a large-ish sheet open but only want to allow certain cells to be able to be alterred............ I seem to be able to either block the whole sheet or else it allows every cell to be over written... Dave :) |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Corey.....certain cell protection.....
coreymcconnell@splicetech(remove bracketed section).com.au
"DB" wrote in message .uk... Nope still not working....can I email you the sheet All I want to lock is yellowed.. Cheers Dave :))) "Corey" wrote in message ... CWith Unprotected sheet. Click on the Small Grey Box Above the 1 and to the Left of the A. This selected ALL cells. IF you WANT MORE CELLS LOCKED than UNLOCKED , Then Format Cells Protection Tick the LOCKED. (UNTICK if MORE are to be UNLOCKED) Then Proceed to Select (ALT+ Cell's) all the cells you want UNLOCKED. Then WHILE cells are Highlighted : Format Cells Protection UNTICK the LOCKED Checkbox When you Protect sheet (IE. Tools Protection Protet Sheet) Tick or Untick what you want to do. (IE Allow Locked Cell to be Protected or NOT) See how ya go.... Corey... Then "DB" wrote in message .uk... Corey.....a few weeks back you helped me try to stop certain cells from being protected...............Dec 12th 2006 13.09 I can't quite get it to work......................... Ive got a large-ish sheet open but only want to allow certain cells to be able to be alterred............ I seem to be able to either block the whole sheet or else it allows every cell to be over written... Dave :) |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Corey.....certain cell protection.....
Corey - I hope you dont mind but ive sent it over..
Dave :) "DB" wrote in message .uk... Nope still not working....can I email you the sheet All I want to lock is yellowed.. Cheers Dave :))) "Corey" wrote in message ... CWith Unprotected sheet. Click on the Small Grey Box Above the 1 and to the Left of the A. This selected ALL cells. IF you WANT MORE CELLS LOCKED than UNLOCKED , Then Format Cells Protection Tick the LOCKED. (UNTICK if MORE are to be UNLOCKED) Then Proceed to Select (ALT+ Cell's) all the cells you want UNLOCKED. Then WHILE cells are Highlighted : Format Cells Protection UNTICK the LOCKED Checkbox When you Protect sheet (IE. Tools Protection Protet Sheet) Tick or Untick what you want to do. (IE Allow Locked Cell to be Protected or NOT) See how ya go.... Corey... Then "DB" wrote in message .uk... Corey.....a few weeks back you helped me try to stop certain cells from being protected...............Dec 12th 2006 13.09 I can't quite get it to work......................... Ive got a large-ish sheet open but only want to allow certain cells to be able to be alterred............ I seem to be able to either block the whole sheet or else it allows every cell to be over written... Dave :) |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Corey.....certain cell protection.....
DB - I'm not Corey; but I have a sheet where some of the cells are locked and
some aren't. Then the sheet is Protected. I choose the cells I want people to be able to change and Format cells as UNLOCKED. All other cells should be LOCKED if you don't want them changed. Then Protect the sheet and they will only be able to change the cells you have made UNLOCKED. HTH. Bethg "DB" wrote: Corey.....a few weeks back you helped me try to stop certain cells from being protected...............Dec 12th 2006 13.09 I can't quite get it to work......................... Ive got a large-ish sheet open but only want to allow certain cells to be able to be alterred............ I seem to be able to either block the whole sheet or else it allows every cell to be over written... Dave :) |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Corey.....certain cell protection.....
Bethb,
I am Corey. It's nice to me you.... :-) "bethg7" wrote in message ... DB - I'm not Corey; but I have a sheet where some of the cells are locked and some aren't. Then the sheet is Protected. I choose the cells I want people to be able to change and Format cells as UNLOCKED. All other cells should be LOCKED if you don't want them changed. Then Protect the sheet and they will only be able to change the cells you have made UNLOCKED. HTH. Bethg "DB" wrote: Corey.....a few weeks back you helped me try to stop certain cells from being protected...............Dec 12th 2006 13.09 I can't quite get it to work......................... Ive got a large-ish sheet open but only want to allow certain cells to be able to be alterred............ I seem to be able to either block the whole sheet or else it allows every cell to be over written... Dave :) |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
Corey.....certain cell protection.....
nothing arrived.
"DB" wrote in message .uk... Corey - I hope you dont mind but ive sent it over.. Dave :) "DB" wrote in message .uk... Nope still not working....can I email you the sheet All I want to lock is yellowed.. Cheers Dave :))) "Corey" wrote in message ... CWith Unprotected sheet. Click on the Small Grey Box Above the 1 and to the Left of the A. This selected ALL cells. IF you WANT MORE CELLS LOCKED than UNLOCKED , Then Format Cells Protection Tick the LOCKED. (UNTICK if MORE are to be UNLOCKED) Then Proceed to Select (ALT+ Cell's) all the cells you want UNLOCKED. Then WHILE cells are Highlighted : Format Cells Protection UNTICK the LOCKED Checkbox When you Protect sheet (IE. Tools Protection Protet Sheet) Tick or Untick what you want to do. (IE Allow Locked Cell to be Protected or NOT) See how ya go.... Corey... Then "DB" wrote in message .uk... Corey.....a few weeks back you helped me try to stop certain cells from being protected...............Dec 12th 2006 13.09 I can't quite get it to work......................... Ive got a large-ish sheet open but only want to allow certain cells to be able to be alterred............ I seem to be able to either block the whole sheet or else it allows every cell to be over written... Dave :) |
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
Corey.....certain cell protection.....
Sent it again...
Cheers Dave :) "Corey" wrote in message ... Bethb, I am Corey. It's nice to me you.... :-) "bethg7" wrote in message ... DB - I'm not Corey; but I have a sheet where some of the cells are locked and some aren't. Then the sheet is Protected. I choose the cells I want people to be able to change and Format cells as UNLOCKED. All other cells should be LOCKED if you don't want them changed. Then Protect the sheet and they will only be able to change the cells you have made UNLOCKED. HTH. Bethg "DB" wrote: Corey.....a few weeks back you helped me try to stop certain cells from being protected...............Dec 12th 2006 13.09 I can't quite get it to work......................... Ive got a large-ish sheet open but only want to allow certain cells to be able to be alterred............ I seem to be able to either block the whole sheet or else it allows every cell to be over written... Dave :) |
#10
Posted to microsoft.public.excel.programming
|
|||
|
|||
Corey.....certain cell protection.....
(Snip).........
Guess What...............Sussed It I was sort of doing things in the wrong order.......what a pleb!! I've got it working fine now , everything tha should be locked..is locked....and anything that I want people to edit can be edited. Many Many Thanks to All the kind people on this Newsgroup who are so quick to try and help others out. Dave :)))))))))))))) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Data Protection Best Practice: AKA: Real Sheet Protection | Excel Discussion (Misc queries) | |||
Excel Data Protection- AKA: Sheet/Macro Password Protection | Setting up and Configuration of Excel | |||
Password Protection - paste to unprotected cell locks the cell | Excel Discussion (Misc queries) | |||
Cell protection | Excel Discussion (Misc queries) | |||
Cell Protection vs. Worksheet Protection | Excel Discussion (Misc queries) |