+ Reply to Thread
Results 1 to 2 of 2

Locking and unlocking of cells

  1. #1
    Registered User
    Join Date
    07-10-2012
    Location
    Pune, India
    MS-Off Ver
    Excel 2010
    Posts
    28

    Locking and unlocking of cells

    Hi Frds,

    I have a problem locking and unlocking if individual cells. I have an excel sheet (Sheet1) which is completely locked with password. In the sheet one i have a checkbox and 6 cells with data .. When the cleckbox value is true then first 3 of the cells to be unlocked and if the checkbox is false, the last 3 data cells to be unlocked for editing.

    I could not able to write code .. please help me this the solution.

    Thanks,
    Sri

  2. #2
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: Locking and unlocking of cells

    Hi Sri,

    Please upload a sample workbook as you have most of the things.. checkboxex, 6 cells and data which will save time of others else they need to create . thanks.

    Regards,
    DILIPandey

    <click on below 'star' if this helps>
    DILIPandey
    +91 9810929744
    dilipandey@gmail.com

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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