| Home | Forums | Reviews | Articles | Register |
 |
| Thread Tools | Rate Thread |
|
Guest
Posts: n/a
|
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  |
|
|
|
|||
|
|
| |
|
Guest
Posts: n/a
|
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" <(E-Mail Removed)> wrote in message news:emBoh.27990$(E-Mail Removed)... > 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 > > > > |
|
|
|
|
|||
|
Guest
Posts: n/a
|
Nope still not working....can I email you the sheet
All I want to lock is yellowed.. Cheers Dave ))"Corey" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)... > 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" <(E-Mail Removed)> wrote in message > news:emBoh.27990$(E-Mail Removed)... >> 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 >> >> >> >> > > |
|
|
|
|
|||
|
Guest
Posts: n/a
|
coreymcconnell@splicetech(remove bracketed section).com.au
"DB" <(E-Mail Removed)> wrote in message news:s2Coh.28025$(E-Mail Removed)... > Nope still not working....can I email you the sheet > > All I want to lock is yellowed.. > > Cheers > > Dave ))> > > "Corey" <(E-Mail Removed)> wrote in message > news:(E-Mail Removed)... >> 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" <(E-Mail Removed)> wrote in message >> news:emBoh.27990$(E-Mail Removed)... >>> 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 >>> >>> >>> >>> >> >> > > |
|
|
|
|
|||
|
Guest
Posts: n/a
|
Corey - I hope you dont mind but ive sent it over..
Dave "DB" <(E-Mail Removed)> wrote in message news:s2Coh.28025$(E-Mail Removed)... > Nope still not working....can I email you the sheet > > All I want to lock is yellowed.. > > Cheers > > Dave ))> > > "Corey" <(E-Mail Removed)> wrote in message > news:(E-Mail Removed)... >> 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" <(E-Mail Removed)> wrote in message >> news:emBoh.27990$(E-Mail Removed)... >>> 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 >>> >>> >>> >>> >> >> > > |
|
|
|
|
|||
|
Guest
Posts: n/a
|
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 > > > > > |
|
|
|
|
|||
|
Guest
Posts: n/a
|
Bethb,
I am Corey. It's nice to me you.... :-) "bethg7" <(E-Mail Removed)> wrote in message news:44891FDA-35E2-46C8-ABE0-(E-Mail Removed)... > 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 >> >> >> >> >> |
|
|
|
|
|||
|
Guest
Posts: n/a
|
nothing arrived.
"DB" <(E-Mail Removed)> wrote in message news:f8Coh.28027$(E-Mail Removed)... > Corey - I hope you dont mind but ive sent it over.. > > Dave > > > "DB" <(E-Mail Removed)> wrote in message > news:s2Coh.28025$(E-Mail Removed)... >> Nope still not working....can I email you the sheet >> >> All I want to lock is yellowed.. >> >> Cheers >> >> Dave ))>> >> >> "Corey" <(E-Mail Removed)> wrote in message >> news:(E-Mail Removed)... >>> 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" <(E-Mail Removed)> wrote in message >>> news:emBoh.27990$(E-Mail Removed)... >>>> 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 >>>> >>>> >>>> >>>> >>> >>> >> >> > > |
|
|
|
|
|||
|
Guest
Posts: n/a
|
Sent it again...
Cheers Dave "Corey" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)... > Bethb, > I am Corey. > It's nice to me you.... :-) > "bethg7" <(E-Mail Removed)> wrote in message > news:44891FDA-35E2-46C8-ABE0-(E-Mail Removed)... >> 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 >>> >>> >>> >>> >>> > > |
|
|
|
|
|||
|
Guest
Posts: n/a
|
(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 ))))))))))))) |
|
|
|
|
|||
|
|
| |
|
| Thread Tools | |
| Rate This Thread | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| cell protection | Pam | Microsoft Excel Misc | 2 | 13th May 2009 03:13 PM |
| Password Protection - paste to unprotected cell locks the cell | =?Utf-8?B?SmltYm9i?= | Microsoft Excel Misc | 7 | 7th Sep 2007 06:22 PM |
| Thanks to Corey and Norman | rlashmore999@hotmail.com | Microsoft Excel Programming | 0 | 26th Apr 2007 11:47 PM |
| Cell Protection vs. Worksheet Protection | =?Utf-8?B?a213aGl0dA==?= | Microsoft Excel Misc | 4 | 24th Sep 2006 02:37 AM |
| cell protection | =?Utf-8?B?RGVi?= | Microsoft Excel Misc | 2 | 31st May 2004 03:29 PM |
