PROCTECTING A CELL WITH FORMULA
Power Query Course in Spanish
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 8 of 8

Thread: PROCTECTING A CELL WITH FORMULA

  1. #1
    New Member
    Join Date
    Mar 2002
    Posts
    21
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    I need to know how i can protect a cell which contain some important information , constant value or formula which i don't want that any one should rewrite.
    AS manay times it happen that the cell which has formula in it is over-rewritten by mistake and the huge formula is Lost.

  2. #2
    Board Regular Steve Hartman's Avatar
    Join Date
    Feb 2002
    Location
    Houston,Texas
    Posts
    417
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    In Excel, go up to the top of the screen and click Help. search on protection. If you still can't figure it out, repost the question.

  3. #3
    New Member
    Join Date
    Mar 2002
    Posts
    21
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I have tried the Protection option also for a cell but it did not worked out.
    That's why iam asking on this forum, so if any one knows it please tell me the steps which i can follow for this.

  4. #4
    Board Regular Steve Hartman's Avatar
    Join Date
    Feb 2002
    Location
    Houston,Texas
    Posts
    417
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    What did you do to try protection and how did it not work?

  5. #5
    Legend NateO's Avatar
    Join Date
    Feb 2002
    Location
    Minneapolis, Mn, USA
    Posts
    9,700
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On the cell in question, make sure you right-click, choose format, click the protection tab and make sure LOCKED is checked.

    Now protect the sheet (tools->protection->protect sheet.....)

    Hope this helps. Cheers,
    Nate

    [ This Message was edited by: NateO on 2002-03-12 13:02 ]

  6. #6
    New Member
    Join Date
    Mar 2002
    Posts
    33
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    A couple of additional points: all cells are locked by default, but this locking does not go into effect until you protect the sheet.
    You may want to protect your sheet with a password, also.
    Choose Protection under the Tools menu.

  7. #7
    MrExcel MVP Mark O'Brien's Avatar
    Join Date
    Feb 2002
    Location
    Columbus, OH, USA
    Posts
    3,530
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I believe in Excel2002 (or XP or whatever it's called) there is an option to protect individual cells. I had this discussion with someone last week.

    Unforunately I do not own Excel 2002 or else I would give you more details. If you don't have it and this formula is worth a couple of hundred (pounds, dollars, euros) then Iwould suggest getting 2002.

  8. #8
    Board Regular
    Join Date
    Mar 2002
    Posts
    76
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    In excel 97, you can selectively Protect cells in a round about way.
    first Unprotect the sheet,
    Remove the lock for cells you DO NOT want protection, by selecting the cells, then choose Format-> cells-> Protection, uncheck locked.
    and then protect the sheet.
    Now, your cell will be protected!

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com