+ Reply to Thread
Results 1 to 3 of 3

Lock / Protection of cells

  1. #1
    Registered User
    Join Date
    10-26-2011
    Location
    Boise, Idaho
    MS-Off Ver
    Excel 2013
    Posts
    62

    Lock / Protection of cells

    I know how to protect cells whereby other users are not able to change the cell, but someone sent me a worksheet where the only cells I can click on are the one I can edit. But I don't know how to do this. Does anyone know how to lock cells where you can't even click on it. Thanks.

  2. #2
    Registered User
    Join Date
    01-20-2017
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    199

    Re: Lock / Protection of cells

    when protecting the sheet you have options. I would recommend only having the checkbox for select unlocked cells.

  3. #3
    Registered User
    Join Date
    10-26-2011
    Location
    Boise, Idaho
    MS-Off Ver
    Excel 2013
    Posts
    62

    Re: Lock / Protection of cells

    Thanks. I got it to work.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Lock cells with formula to prevent manual data entry into those cells.
    By jitterbug888 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-02-2015, 12:24 AM
  2. [SOLVED] Sheet Protection column width lock
    By Red fuji in forum Excel General
    Replies: 1
    Last Post: 01-16-2014, 05:30 PM
  3. Replies: 5
    Last Post: 07-15-2013, 03:57 AM
  4. Replies: 1
    Last Post: 03-11-2013, 05:44 PM
  5. Replies: 2
    Last Post: 02-22-2012, 10:10 AM
  6. lock cells for edit without using sheet protection
    By jimjaix in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 03-11-2009, 10:32 AM
  7. Can I lock cells or do I have to lock the worksheet?
    By jmbtexas in forum Excel General
    Replies: 4
    Last Post: 11-11-2008, 02:26 PM

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