+ Reply to Thread
Results 1 to 2 of 2

How do I protect a cell formula from being overwritten

  1. #1
    wc
    Guest

    How do I protect a cell formula from being overwritten

    I want to prevent input to a cell to prevent someone from replacing the
    formula result with a contsant value.

  2. #2
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258
    Hello Wc,

    You need to protect your worksheet. On the menu bar go to Tools | Protection | Protect Sheet... A dialog will appear giving you protection options. One of which is using a password to protect the sheet. You can use a password if you want added protection for the worksheet.

    If there are cells that will be used for inputting data, you will need to "Unlock" the cells. By default all cells on a worksheet are locked. This is only in effect when the worksheet is protected. On the menu bar go to Format | Cells... | Protection (This is a Tab in the dialog) and click the "Locked" checkbox to clear it.

    Sincerely,
    Leith Ross

+ 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