Results 1 to 35 of 35

Need to protect formula but allow input

Threaded View

  1. #1
    Registered User
    Join Date
    07-27-2008
    Location
    San Diego
    Posts
    40

    Need to protect formula but allow input

    I was wondering how you can protect a formula but still allow editing in the cell. Right now I have certain columns locked while allowing others to be edited. I have a formula in one column that needs to be edited if need be but if they make a mistake and hit delete then my formula disappears and it throws the whole sheet off. Is there a way to protect your formula maybe by putting it in a different cell that can be locked and referencing the cell where they can input?

    Thanks
    Last edited by hbasten; 05-30-2009 at 07:11 PM. Reason: Issue not resolved

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