+ Reply to Thread
Results 1 to 6 of 6

Protecting cells in a worksheet

  1. #1
    Forum Contributor
    Join Date
    05-17-2010
    Location
    Nigeria, Owerri
    MS-Off Ver
    Excel 2007 and 2013
    Posts
    247

    Protecting cells in a worksheet

    Hi all,

    Please I have some cells in a worksheet that have several formulars I would not want to be tampered with. So I need to lock the cells so that they can only be edited with password. The process I know which is going through Format>Cells>Protection.......... only gives a temporary solution.

    I want the cells locked in such a way that each time they are tampered with, a password will be requested.

    Please help.
    Last edited by st_judeu@yahoo.com; 06-16-2010 at 09:32 AM.

  2. #2
    Forum Guru teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,364

    Re: Protecting cells in a worksheet

    Hello,

    select the cell(s) and then click Tools - Protection - Allow users to edit ranges

    Specify a password. Make sure the cells are formatted as locked. Protect the sheet with a (different) password.
    Now, when a user tries to edit one of the previously selected and protected cells, they will be asked for a password. This password will only unlock the cells, not the whole sheet.

    cheers,

  3. #3
    Forum Contributor
    Join Date
    05-17-2010
    Location
    Nigeria, Owerri
    MS-Off Ver
    Excel 2007 and 2013
    Posts
    247

    Re: Protecting cells in a worksheet

    Please I tried the process but it did not work.

    Probably because I do not know how to format cell as locked. Please I still need your help.

    Thanks

  4. #4
    Forum Guru teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,364

    Re: Protecting cells in a worksheet

    Select the cell, open the Format dialog, click the Protection tab and tick Locked.

    By default, all cells are set to Locked. If you want users to edit cells after the sheet is protected, you need to untick this option.

    cheers,

  5. #5
    Forum Contributor
    Join Date
    05-17-2010
    Location
    Nigeria, Owerri
    MS-Off Ver
    Excel 2007 and 2013
    Posts
    247

    Re: Protecting cells in a worksheet

    Thanks Teylyn. It worked perfectly. I appreciate.

  6. #6
    Forum Contributor
    Join Date
    05-17-2010
    Location
    Nigeria, Owerri
    MS-Off Ver
    Excel 2007 and 2013
    Posts
    247

    Re: Protecting cells in a worksheet

    Good day all.
    Please I was using this solution in Office 2003 and it worked fine. But I'm having difficultly applying it in Office 2007. What are the steps for locking cells with password in Office 2007? Thanks.

+ 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