Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    Jul 2014
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    How do you protect cells in Excel so no one can over type them

    How do you protect cells in Excell so no one can over type them i.e 2 X 60 = 120 how do i protect the cell with 60 in it


    2 60 120
    3 70 210
    4 80 320

  2. #2
    2 Star Lounger Bender's Avatar
    Join Date
    Mar 2010
    Location
    Winston-Salem, NC USA
    Posts
    134
    Thanks
    17
    Thanked 18 Times in 17 Posts
    I believe it's as easy as right clicking the cell, Select "Format Cells" from the pop-up menu, select the "Protection" tab in the dialog, then check whether you want the cell locked and/or hidden. After all that you will need to protect the sheet. You can do that by selecting the Review menu item then clicking the "Protect Sheet" item. Just fill in the desired properties in the subsequent dialog.
    Do your part!!! Report SPAM to http://www.spamcop.net/

  3. #3
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    9,894
    Thanks
    420
    Thanked 1,585 Times in 1,434 Posts
    Madasafish,

    Welcome to the Lounge as a new poster!

    Here's an excerpt from an Excel XP course I wrote that covers the concepts on cell protection. Granted the illustrations use the command structure from Excel XP but the concepts are the same only the location of the command trees have changed. HTH
    Excel XP Introduction & Database Course.pdf
    May the Forces of good computing be with you!

    RG

    PowerShell & VBA Rule!

    My Systems: Desktop Specs
    Laptop Specs

  4. #4
    Gold Lounger Maudibe's Avatar
    Join Date
    Aug 2010
    Location
    Pa, USA
    Posts
    2,919
    Thanks
    152
    Thanked 746 Times in 678 Posts
    As Bender states, locking a cell has no effect unless you protect the sheet. To avoid the process of formatting the cells as protected one by one, while holding down the ctrl key, click on each cell you wish to protect highlighting them all. Right click on one of them then follow Benders instructions. If you leave the password field blank when protecting the sheet, you will not need a password when it comes time to unprotect it.

    Be careful if you are using VBA code that manipulates locked cells. The code will fail if provisions to unlock the cells are not coded to execute prior to the manipulation. As an alternative, tThe use of the Worksheets(worksheet).Protect UserInterFaceOnly:=True in the Worksheet_Open routine will allow the code to operate on locked cells when the sheet is protected.

    Maud

Posting Permissions

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