Results 1 to 3 of 3

Event code to unlock cells

Threaded View

  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

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