Tags: a13, a14, cell, depending, example, excel, formula, function, lock, microsoft, msdn, returend, returns, software, unlock, upon, vanue

FORMULA/FUNCTION TO LOCK AND UNLOCK A CELL

On Microsoft » Microsoft Excel

1,132 words with 2 Comments; publish: Thu, 22 May 2008 05:50:00 GMT; (30662.00, « »)

I AM TRYING TO LOCK A CELL DEPENDING UPON THE VANUE THAT HAS BEEN RETUREND

FROM ANOTHER CELL.fOR EXAMPLE IF CELL a13 RETURNS 1 THEN CELL a14 SHOULD BE

LOCKED SO THAT NO ONE CAN CHANGE THE CELL.

PEASE HELP

All Comments

Leave a comment...

  • 2 Comments
    • Use Data Validation:

      Click on A14 and:

      Data > Validation... > Custom > Formula >

      =A13 <> 1

      --

      Gary''s Student - gsnu200780

      "Ridhi" wrote:

      > I AM TRYING TO LOCK A CELL DEPENDING UPON THE VANUE THAT HAS BEEN RETUREND

      > FROM ANOTHER CELL.fOR EXAMPLE IF CELL a13 RETURNS 1 THEN CELL a14 SHOULD BE

      > LOCKED SO THAT NO ONE CAN CHANGE THE CELL.

      > PEASE HELP

      >

      #1; Thu, 22 May 2008 05:52:00 GMT
    • Please get your caps lock key repaired, and stop SHOUTING.

      --

      David Biddulph

      "Ridhi" <Ridhi.excel.todaysummary.com.discussions.microsoft.com> wrote in message

      news:89742C93-DD41-4AC9-BF91-620B7A277ECB.excel.todaysummary.com.microsoft.com...

      >I AM TRYING TO LOCK A CELL DEPENDING UPON THE VANUE THAT HAS BEEN RETUREND

      > FROM ANOTHER CELL.fOR EXAMPLE IF CELL a13 RETURNS 1 THEN CELL a14 SHOULD

      > BE

      > LOCKED SO THAT NO ONE CAN CHANGE THE CELL.

      > PEASE HELP

      >

      #2; Thu, 22 May 2008 05:53:00 GMT