+ Reply to Thread
Results 1 to 3 of 3

Event code to unlock cells

  1. #1
    Registered User
    Join Date
    11-11-2012
    Location
    Atlanta, GA
    MS-Off Ver
    Excel 2016
    Posts
    8

    Event code to unlock cells

    I've attempted to write event code to unlock certain cells within a column. The code is supposed to unlock otherwise locked cells for the months of March, May, August and November. The trigger cell is the cell displaying the month. I can't seem to make it work. Help

    I've attached the workbook with the event code. No password is needed to unlock.
    Attached Files Attached Files

  2. #2
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    7,926

    Re: Event code to unlock cells

    Here's my take on it:
    Please Login or Register  to view this content.
    BTW: if the macro recorder produces code like:
    Please Login or Register  to view this content.
    You can usually replace it with
    Please Login or Register  to view this content.
    I did that with your code.
    Attached Files Attached Files
    One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.

    A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.

  3. #3
    Registered User
    Join Date
    11-11-2012
    Location
    Atlanta, GA
    MS-Off Ver
    Excel 2016
    Posts
    8

    Re: Event code to unlock cells

    My apologies for this tardy response. Thank you for the solution. With some minor tweaking it works perfectly. Your help is much appreciated.

+ 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. Replies: 12
    Last Post: 12-30-2017, 10:35 AM
  2. Need Event Procedure to Unlock a Protect Cell if Criteria is Met
    By MaineLabRat in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-15-2017, 02:50 PM
  3. VBA Code to unlock cells on a protected sheet based on cell value in another worksheet
    By mr_irrelevant in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-13-2014, 04:02 PM
  4. [SOLVED] VBA Code Change Event Code When 2 cells are selected
    By bjnockle in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 07-16-2014, 06:08 PM
  5. VBA Code to lock and unlock cells.
    By gerald6126 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-26-2013, 03:08 PM
  6. [SOLVED] VBA code to unlock select cells
    By christopherjward in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-20-2013, 10:23 AM
  7. Code to grey out and lock/unlock certain cells
    By Glensafro in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-10-2012, 11:59 AM

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