+ Reply to Thread
Results 1 to 3 of 3

Locking a Sheet

  1. 10-04-2016, 10:12 AM #1
    agroeneveld
    agroeneveld is offline
    Registered User
    Join Date
    08-10-2016
    Location
    US
    MS-Off Ver
    365
    Posts
    70

    Locking a Sheet

    How do you lock only parts of a sheet?
    Reply With QuoteRegister To Reply
  2. 10-04-2016, 10:16 AM #2
    Wiggy74
    Wiggy74 is offline
    Registered User
    Join Date
    10-31-2011
    Location
    Kent, England
    MS-Off Ver
    Excel 2010
    Posts
    43

    Re: Locking a Sheet

    The answer you seek can be found here my friend.

    https://support.office.com/en-gb/art...ad=GB&fromAR=1
    Reply With QuoteRegister To Reply
  3. 10-04-2016, 10:17 AM #3
    xlnitwit
    xlnitwit is offline
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: Locking a Sheet

    1. Select all the cells, choose Format - Cells and on the Protection tab uncheck the Locked property.
    2. Select the cells you wish locked and repeat the above but check the property.
    3. Protect the worksheet, selecting any options you wish to allow.
    Don
    Please remember to mark your thread 'Solved' when appropriate.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Locking Sheet before close
    By JohnDoh in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-26-2015, 04:24 AM
  2. Workbook locking on certain tab/sheet
    By tmill29 in forum Excel General
    Replies: 0
    Last Post: 06-12-2014, 04:55 PM
  3. Sheet Keeps Auto-Locking Itself
    By bdoguc in forum Excel General
    Replies: 2
    Last Post: 05-02-2011, 06:33 PM
  4. Locking Sheet Order
    By dfleming in forum Excel General
    Replies: 10
    Last Post: 09-09-2010, 07:17 AM
  5. locking the VB window of a sheet
    By ss_bb_24 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-07-2007, 03:28 AM
  6. locking formula in cells in without locking whole sheet
    By SuziQ in forum Excel General
    Replies: 1
    Last Post: 07-21-2006, 11:05 AM
  7. Locking a sheet??
    By mcr1 in forum Excel General
    Replies: 1
    Last Post: 01-09-2006, 01:31 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1