|  | Cells that won't Lock! | | |
| | | Noel S Pamfree |  |
|  Posted: Mon Jul 21, 2008 1:37 pm Post subject: 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 |
| |
| | | Don Guillett | |
| | Posted: Mon Jul 21, 2008 1:45 pm Post subject: 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...
| Quote: | 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
|
|
| |
| | | Noel S Pamfree | |
| | Posted: Mon Jul 21, 2008 2:55 pm Post subject: 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...
| Quote: | 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
|
|
| |
| | | Don Guillett | |
| | Posted: Mon Jul 21, 2008 3:10 pm Post subject: 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...
| Quote: | 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
|
|
| |
| | | Noel S Pamfree | |
| | Posted: Mon Jul 21, 2008 4:25 pm Post subject: 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...
| Quote: | 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
|
|
| |
| | | Don Guillett | |
| | Posted: Mon Jul 21, 2008 5:46 pm Post subject: 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...
| Quote: | 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
|
|
| |
| | | S | |
| | Posted: Tue Jul 22, 2008 9:10 pm Post subject: 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...
| Quote: | 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
|
|
| |
|
|
