Results 1 to 1 of 1

Hide Columns based on Date value in cell (Worksheet Change event)

Threaded View

  1. #1
    Registered User
    Join Date
    03-14-2011
    Location
    Cleveland, OH
    MS-Off Ver
    Excel 2007
    Posts
    3

    Hide Columns based on Date value in cell (Worksheet Change event)

    Looking for a worksheet_change event macro that will automatically hide columns based on a value in cell S3. S3 is a data validation pick list of months based on the 1st day of each (e.g. 1/1/2014, 2/1/2014, 3/1/2014, etc.). I have date columns in row 6 from columns T through AQ. These values are 1/1/2014 (T6), 2/1/2104 (U6), 3/1/2014 (V6)....12/1/2015 (AQ6). I would like to hide columns that have a date in row 6 (T6:AQ6) that is LESS THAN (<) the date in S3 after the cell is value is changed.

    Hope this makes sense. Let me know if you have any ?'s.

    Thank you!!!
    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. Worksheet Change Event based on value of a cell
    By ron2k_1 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-26-2014, 01:01 PM
  2. [SOLVED] Worksheet change event code to display message box based on active cell offset content
    By Nitefox in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-12-2014, 02:52 PM
  3. [SOLVED] Can't hide/unhide rows under worksheet change event?
    By Don Wiss in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-24-2005, 07:02 PM
  4. [SOLVED] How do I automatically hide columns in a worksheet based on a cell value?
    By dkhedkar in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-04-2005, 09:06 PM
  5. Replies: 0
    Last Post: 03-04-2005, 02:43 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