Results 1 to 54 of 54

Macro/VBA for auto hide unhide rows

Threaded View

  1. #1
    Registered User
    Join Date
    10-17-2013
    Location
    Ardooie
    MS-Off Ver
    Excel 2007
    Posts
    67

    Macro/VBA for auto hide unhide rows

    This is the second thread I make over here, but it concerns the same question from my first thread (but a little more difficult, since I had to change my sheet)

    Attached, you can see my file where the code has to it's work

    I'll try to explain it simple, but if I wasn't clear on something, please ask me.

    ROW 12 = always visible
    ROW 13= hiden if C12 & D12 & E12 & F12 & G12 are empty. From the moment the user makes an input in one of those 5 cells, ROW 13 should unhide
    ROW 14= hiden if C13 & D13 & E13 & F13 & G13 are empty. From the moment the user makes an input in one of those 5 cells, ROW 14 should unhide
    ...
    ROW 21 = hiden if C20 & D20 & E20 & F20 & G20 are empty. From the moment the user makes an input in one of those 5 cells, ROW 21 should unhide

    Same store on ROW 41 till 50; 65 - 74; 80 - 89; 92 - 94.
    Always one row that is always visible by default (the first one), and the ones behind become visible from the moment user makes an input in the row before.

    It's important that the code has no restrictions on the amount of rows, because rows will be inserted or deleted in time (concerning rows 4 - 11; 22 - 40; ...)
    Next thing very important to me, is that the excisting macro's (color cells with comment & make user input auto uppercase) keep working.
    And last but not least: if C12 & C13 & C14 has an value, and the user deletes C13, C14 should keep being visible (in my thread before it was hiding rows with values in).

    Hope I made it clear enough
    Thanks for any help in advance !
    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. [SOLVED] Auto hide/unhide rows that have empty cells ( Preferably VBA Code)
    By carlandtina02 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 03-09-2016, 07:06 PM
  2. [SOLVED] How to auto hide/unhide rows based on value of sum
    By wesleeptheylive in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 12-27-2013, 04:34 PM
  3. [SOLVED] Auto Hide and Unhide Rows Based
    By Kosmik in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 12-05-2013, 10:09 AM
  4. Auto Hide & Unhide Rows Upon Sheet Selection
    By Sleeper in forum Excel General
    Replies: 4
    Last Post: 01-24-2013, 02:00 PM
  5. Auto Hide or Unhide rows.
    By Michael S in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-19-2009, 06:04 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