 |
 |
|
|
|
07-21-2008, 03:37 PM
|
|||
|
|||
|
Cells that won't Lock!
I am using Excel 2007 and I need to lock two cells to prevent anyone
removing the formulae. I highlight the two cells and on the Home tab / Cells / Format, I click on 'Lock' in the drop-down menu. However, having done all this I can still over-type in those cells and the formulae disappear. What am I doing wrong? Noel 
|
|
07-21-2008, 03:45 PM
|
|||
|
|||
|
Re: Cells that won't Lock!
Cells are locked by default. So, locking the cells does nothing until you
protect the sheet. Right click sheet tab>protection. -- Don Guillett Microsoft MVP Excel SalesAid Software dguillett1@austin.rr.com "Noel S Pamfree" <Noel.spamfree@hotmail.com> wrote in message news:%23cvV2e06IHA.2332@TK2MSFTNGP03.phx.gbl... >I am using Excel 2007 and I need to lock two cells to prevent anyone >removing the formulae. > > I highlight the two cells and on the Home tab / Cells / Format, I click on > 'Lock' in the drop-down menu. > > However, having done all this I can still over-type in those cells and the > formulae disappear. > > What am I doing wrong? > > Noel >
|
|
07-21-2008, 04:55 PM
|
|||
|
|||
|
Re: Cells that won't Lock!
Thanks for that.
The problem now is that the whole sheet is protected and I am unable to enter the figures in the cells I didn't want to protect. The worksheet involves the calculation of one currency to another. I need to stop anyone altering the formulae that does this but they need to be able to enter the amounts they want to convert. Is there a way I can just protect the two cells I need to remain unchanged? Noel "Don Guillett" <dguillett1@austin.rr.com> wrote in message news:%23PxzEj06IHA.3672@TK2MSFTNGP04.phx.gbl... > Cells are locked by default. So, locking the cells does nothing until you > protect the sheet. Right click sheet tab>protection. > > -- > Don Guillett > Microsoft MVP Excel > SalesAid Software > dguillett1@austin.rr.com > "Noel S Pamfree" <Noel.spamfree@hotmail.com> wrote in message > news:%23cvV2e06IHA.2332@TK2MSFTNGP03.phx.gbl... >>I am using Excel 2007 and I need to lock two cells to prevent anyone >>removing the formulae. >> >> I highlight the two cells and on the Home tab / Cells / Format, I click >> on 'Lock' in the drop-down menu. >> >> However, having done all this I can still over-type in those cells and >> the formulae disappear. >> >> What am I doing wrong? >> >> Noel >> >
|
|
07-21-2008, 05:10 PM
|
|||
|
|||
|
Re: Cells that won't Lock!
Put your cursor on the cells block just to the left of the col A title and
above the 1 title row.Right click>Unlock all>now goto the ones to protect>lock>protect sheet. Basic. -- Don Guillett Microsoft MVP Excel SalesAid Software dguillett1@austin.rr.com "Noel S Pamfree" <Noel.spamfree@hotmail.com> wrote in message news:%23Uf3jK16IHA.4092@TK2MSFTNGP05.phx.gbl... > Thanks for that. > > The problem now is that the whole sheet is protected and I am unable to > enter the figures in the cells I didn't want to protect. > > The worksheet involves the calculation of one currency to another. I need > to stop anyone altering the formulae that does this but they need to be > able to enter the amounts they want to convert. > > Is there a way I can just protect the two cells I need to remain > unchanged? > > Noel > > > "Don Guillett" <dguillett1@austin.rr.com> wrote in message > news:%23PxzEj06IHA.3672@TK2MSFTNGP04.phx.gbl... >> Cells are locked by default. So, locking the cells does nothing until you >> protect the sheet. Right click sheet tab>protection. >> >> -- >> Don Guillett >> Microsoft MVP Excel >> SalesAid Software >> dguillett1@austin.rr.com >> "Noel S Pamfree" <Noel.spamfree@hotmail.com> wrote in message >> news:%23cvV2e06IHA.2332@TK2MSFTNGP03.phx.gbl... >>>I am using Excel 2007 and I need to lock two cells to prevent anyone >>>removing the formulae. >>> >>> I highlight the two cells and on the Home tab / Cells / Format, I click >>> on 'Lock' in the drop-down menu. >>> >>> However, having done all this I can still over-type in those cells and >>> the formulae disappear. >>> >>> What am I doing wrong? >>> >>> Noel >>> >> > >
|
|
07-21-2008, 06:25 PM
|
|||
|
|||
|
Re: Cells that won't Lock!
Thanks again for your help.
I don't know if I am doing something stupid but when I right click on the rectangle with the triangle in it (left of Column A and above Row 1) I do not get the option to 'Unlock All'. I am using Excel 2007. Noel "Don Guillett" <dguillett1@austin.rr.com> wrote in message news:ukQllS16IHA.1204@TK2MSFTNGP04.phx.gbl... > Put your cursor on the cells block just to the left of the col A title and > above the 1 title row.Right click>Unlock all>now goto the ones to > protect>lock>protect sheet. Basic. > > -- > Don Guillett > Microsoft MVP Excel > SalesAid Software > dguillett1@austin.rr.com > "Noel S Pamfree" <Noel.spamfree@hotmail.com> wrote in message > news:%23Uf3jK16IHA.4092@TK2MSFTNGP05.phx.gbl... >> Thanks for that. >> >> The problem now is that the whole sheet is protected and I am unable to >> enter the figures in the cells I didn't want to protect. >> >> The worksheet involves the calculation of one currency to another. I need >> to stop anyone altering the formulae that does this but they need to be >> able to enter the amounts they want to convert. >> >> Is there a way I can just protect the two cells I need to remain >> unchanged? >> >> Noel >> >> >> "Don Guillett" <dguillett1@austin.rr.com> wrote in message >> news:%23PxzEj06IHA.3672@TK2MSFTNGP04.phx.gbl... >>> Cells are locked by default. So, locking the cells does nothing until >>> you protect the sheet. Right click sheet tab>protection. >>> >>> -- >>> Don Guillett >>> Microsoft MVP Excel >>> SalesAid Software >>> dguillett1@austin.rr.com >>> "Noel S Pamfree" <Noel.spamfree@hotmail.com> wrote in message >>> news:%23cvV2e06IHA.2332@TK2MSFTNGP03.phx.gbl... >>>>I am using Excel 2007 and I need to lock two cells to prevent anyone >>>>removing the formulae. >>>> >>>> I highlight the two cells and on the Home tab / Cells / Format, I click >>>> on 'Lock' in the drop-down menu. >>>> >>>> However, having done all this I can still over-type in those cells and >>>> the formulae disappear. >>>> >>>> What am I doing wrong? >>>> >>>> Noel >>>> >>> >> >> >
|
|
07-21-2008, 07:46 PM
|
|||
|
|||
|
Re: Cells that won't Lock!
One more time.
Right click on the "triangle" to select ALL CELLS>format>protection>uncheck locked................ got it? -- Don Guillett Microsoft MVP Excel SalesAid Software dguillett1@austin.rr.com "Noel S Pamfree" <Noel.spamfree@hotmail.com> wrote in message news:%23$8wb816IHA.1196@TK2MSFTNGP05.phx.gbl... > Thanks again for your help. > > I don't know if I am doing something stupid but when I right click on the > rectangle with the triangle in it (left of Column A and above Row 1) I do > not get the option to 'Unlock All'. > > I am using Excel 2007. > > Noel > > > "Don Guillett" <dguillett1@austin.rr.com> wrote in message > news:ukQllS16IHA.1204@TK2MSFTNGP04.phx.gbl... >> Put your cursor on the cells block just to the left of the col A title >> and above the 1 title row.Right click>Unlock all>now goto the ones to >> protect>lock>protect sheet. Basic. >> >> -- >> Don Guillett >> Microsoft MVP Excel >> SalesAid Software >> dguillett1@austin.rr.com >> "Noel S Pamfree" <Noel.spamfree@hotmail.com> wrote in message >> news:%23Uf3jK16IHA.4092@TK2MSFTNGP05.phx.gbl... >>> Thanks for that. >>> >>> The problem now is that the whole sheet is protected and I am unable to >>> enter the figures in the cells I didn't want to protect. >>> >>> The worksheet involves the calculation of one currency to another. I >>> need to stop anyone altering the formulae that does this but they need >>> to be able to enter the amounts they want to convert. >>> >>> Is there a way I can just protect the two cells I need to remain >>> unchanged? >>> >>> Noel >>> >>> >>> "Don Guillett" <dguillett1@austin.rr.com> wrote in message >>> news:%23PxzEj06IHA.3672@TK2MSFTNGP04.phx.gbl... >>>> Cells are locked by default. So, locking the cells does nothing until >>>> you protect the sheet. Right click sheet tab>protection. >>>> >>>> -- >>>> Don Guillett >>>> Microsoft MVP Excel >>>> SalesAid Software >>>> dguillett1@austin.rr.com >>>> "Noel S Pamfree" <Noel.spamfree@hotmail.com> wrote in message >>>> news:%23cvV2e06IHA.2332@TK2MSFTNGP03.phx.gbl... >>>>>I am using Excel 2007 and I need to lock two cells to prevent anyone >>>>>removing the formulae. >>>>> >>>>> I highlight the two cells and on the Home tab / Cells / Format, I >>>>> click on 'Lock' in the drop-down menu. >>>>> >>>>> However, having done all this I can still over-type in those cells and >>>>> the formulae disappear. >>>>> >>>>> What am I doing wrong? >>>>> >>>>> Noel >>>>> >>>> >>> >>> >> > >
|
|
07-22-2008, 11:10 PM
|
|||
|
|||
|
Re: Cells that won't Lock!
Noel,
I have the same problem and its a case of the cells you want protected to be locked or unlocked and then protect the sheet. I can never get this right first time and can never remember the correct order and have to play around til it works. It is basic stuff to the experts but damned if I can ever get it first time. I can never remember if I should lock or unlock the cells I want to protect and then the sheet :-) Play around you will get it!. "Don Guillett" <dguillett1@austin.rr.com> wrote in message news:el1tIq26IHA.4204@TK2MSFTNGP03.phx.gbl... > One more time. > Right click on the "triangle" to select ALL > CELLS>format>protection>uncheck locked................ got it? > > -- > Don Guillett > Microsoft MVP Excel > SalesAid Software > dguillett1@austin.rr.com > "Noel S Pamfree" <Noel.spamfree@hotmail.com> wrote in message > news:%23$8wb816IHA.1196@TK2MSFTNGP05.phx.gbl... >> Thanks again for your help. >> >> I don't know if I am doing something stupid but when I right click on the >> rectangle with the triangle in it (left of Column A and above Row 1) I do >> not get the option to 'Unlock All'. >> >> I am using Excel 2007. >> >> Noel >> >> >> "Don Guillett" <dguillett1@austin.rr.com> wrote in message >> news:ukQllS16IHA.1204@TK2MSFTNGP04.phx.gbl... >>> Put your cursor on the cells block just to the left of the col A title >>> and above the 1 title row.Right click>Unlock all>now goto the ones to >>> protect>lock>protect sheet. Basic. >>> >>> -- >>> Don Guillett >>> Microsoft MVP Excel >>> SalesAid Software >>> dguillett1@austin.rr.com >>> "Noel S Pamfree" <Noel.spamfree@hotmail.com> wrote in message >>> news:%23Uf3jK16IHA.4092@TK2MSFTNGP05.phx.gbl... >>>> Thanks for that. >>>> >>>> The problem now is that the whole sheet is protected and I am unable to >>>> enter the figures in the cells I didn't want to protect. >>>> >>>> The worksheet involves the calculation of one currency to another. I >>>> need to stop anyone altering the formulae that does this but they need >>>> to be able to enter the amounts they want to convert. >>>> >>>> Is there a way I can just protect the two cells I need to remain >>>> unchanged? >>>> >>>> Noel >>>> >>>> >>>> "Don Guillett" <dguillett1@austin.rr.com> wrote in message >>>> news:%23PxzEj06IHA.3672@TK2MSFTNGP04.phx.gbl... >>>>> Cells are locked by default. So, locking the cells does nothing until >>>>> you protect the sheet. Right click sheet tab>protection. >>>>> >>>>> -- >>>>> Don Guillett >>>>> Microsoft MVP Excel >>>>> SalesAid Software >>>>> dguillett1@austin.rr.com >>>>> "Noel S Pamfree" <Noel.spamfree@hotmail.com> wrote in message >>>>> news:%23cvV2e06IHA.2332@TK2MSFTNGP03.phx.gbl... >>>>>>I am using Excel 2007 and I need to lock two cells to prevent anyone >>>>>>removing the formulae. >>>>>> >>>>>> I highlight the two cells and on the Home tab / Cells / Format, I >>>>>> click on 'Lock' in the drop-down menu. >>>>>> >>>>>> However, having done all this I can still over-type in those cells >>>>>> and the formulae disappear. >>>>>> >>>>>> What am I doing wrong? >>>>>> >>>>>> Noel >>>>>> >>>>> >>>> >>>> >>> >> >> >
|
 |
|
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
