Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: How to protect collumn formula

  1. #1
    Guest

    Default

    Dear,

    I setup a formula for collumn, and I don't want anyone to change it.

    But I don't know how to setup it.

    Lyvia

  2. #2
    Rest in Peace
    Join Date
    Feb 2002
    Posts
    1,582
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi

    Safest way is to Protect your Sheet. Tools>Protection>Protect sheet. This will protect all "Locked" cells and all cells are locked by default. If you only want formula cells locked:

    1. Push Ctrl+A (selects all cells)

    2. Go to Format>Cells>Protection- uncheck "Locked" then you can also check "Hidden" if you want. This means your underlying formulas will not be visible.Click OK.

    3.with any single cell selected Push F5, click "Special" then check "Formula" and click OK. This will select all formula cells.

    4. Again go to Format>cell-Protection , but this time check the "LOcked" option.


    5. Protect your sheet.
    _________________
    Kind Regards
    Dave Hawley
    OzGrid Business Applications
    Microsoft Excel/VBA Training
    If it's Excel, then it's us!

    [ This Message was edited by: Dave Hawley on 2002-03-11 02:04 ]

Some videos you may like

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
  •