+ Reply to Thread
Results 1 to 4 of 4

Protect formula from change or how to disappear it?

  1. #1
    Registered User
    Join Date
    11-03-2012
    Location
    Egypt
    MS-Off Ver
    Excel 2007
    Posts
    13

    Exclamation Protect formula from change or how to disappear it?

    Dear All,
    I ask if it possible to make protection against formula that existed on several fields from changing or disappear the view to be not monitored only by some identifications or password..

    I don't know if my message clear but I think it important for save works,,

    Ex: I need this formula not appear for other users:

    =IF(((ROUNDUP((AK10-AL10)/30,0)*1.5%))>=15%,15%,((ROUNDUP((AK10-AL10)/30,0))*1.5%))

    Deeply thanks,

  2. #2
    Forum Contributor dogberry's Avatar
    Join Date
    07-15-2012
    Location
    Wales, UK
    MS-Off Ver
    Excel 2010
    Posts
    624

    Re: Protect formula from change or how to disappear it?

    Hi

    Click on format cells protection and select hide.

    Chris
    Click my star if I helped Thanks

  3. #3
    Registered User
    Join Date
    11-16-2012
    Location
    adelaide
    MS-Off Ver
    Excel 07/10
    Posts
    56

    Re: Protect formula from change or how to disappear it?

    Hey there,

    Step 1: Select the entire excel sheet from the little arrow before Column A and above row 1
    Step 2: Right Click and got to Format Cells
    Step 3: Go to Last option "Protection" and untick Locked and Hidden Checkboxes and click OK
    Step 4: Go to the cell where your formula is, for eg b1, right click on it and then go to format cells, protection and now check both locked and hidden checkboxes.
    Step 5: Password protect your sheet by going to Review and "Protect Sheet"

    This will allow users to edit other cells but not the one with your formula in it.
    Hope this helps...


  4. #4
    Registered User
    Join Date
    11-03-2012
    Location
    Egypt
    MS-Off Ver
    Excel 2007
    Posts
    13

    Re: Protect formula from change or how to disappear it?

    Deeply Thanks, its done...

+ 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