+ Reply to Thread
Results 1 to 2 of 2

How to protect the cell's formula not be deleted

  1. #1
    Man Utd
    Guest

    How to protect the cell's formula not be deleted

    I have formula in cells, how can I protect this formula from being deleted
    when the user select this cell and delete the content.

    eg.
    in cell C10, the formula is =A10 * 2

    If the A10 has value of 10, then C10 will be 20.
    If the user select A10 and delete the content 20, then the formula will also
    be deleted.
    How do I prevent that ?



  2. #2
    Forum Contributor
    Join Date
    06-10-2004
    Location
    India
    Posts
    1,066
    Select all cells
    Format > cells > protection > Uncheck Locked
    Select the cell with formula
    Format > cells > protection > Check Locked
    Tools > Protection > Protect sheet (password is optional)

    Mangesh

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1