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
    Star Lounger
    Join Date
    Mar 2010
    Location
    Winston-Salem, NC USA
    Posts
    66
    Thanks
    12
    Thanked 4 Times in 4 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,436
    Thanks
    372
    Thanked 1,457 Times in 1,326 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,637
    Thanks
    115
    Thanked 650 Times in 592 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
  •