hiding cells

  1. D

    Dropdown hiding other cells goes wrong

    I've got a code from one of you guy's and it works perfectly, but if I change any other dropdown on the sheet 'Panelen en Omvormers', the rows disappear again..:confused:.. very strange.. Here is my sheet code now: (the above code is another code which hides a cell on the same sheet, that's not...
  2. andrewb90

    Use VBA to hide rows based on the cell value

    Hello All, I am a little stumped on this, and unfortunately the macro recorder is no good here... What I am trying to do is look at the active sheet and if there is no data in D5, then that row would be hidden. I would want to continue all the way down to row 70, however, Rows 15, 25, & 38...
  3. andrewb90

    Data Validation

    I have a simple macro that hides a few rows. When those rows are hidden, I need a way to restrict any data entry until those rows have been unhidden. I am thinking data validation, but I have no idea how I would make that work. When rows 16:17 are hidden, I need to restrict any entry in cells...
  4. andrewb90

    Data Validation based on cell visibility

    I have a simple macro that hides a few rows. When those rows are hidden, I need a way to restrict any data entry until those rows have been unhidden. I am thinking data validation, but I have no idea how I would make that work. When rows 16:17 are hidden, I need to restrict any entry in cells...
  5. andrewb90

    Hiding rows based on cell contents

    I need to get a formula or a piece of code that looks at cell D3 and if the number is not 5 then rows 800 & 810 will be hidden. Can anybody help with this? Many Thanks, Andrew
  6. andrewb90

    Images in cells do not hide with cell

    I have a few cells that have a small image in them, and when I hide the row or column that contains those cells, the images stay put and appear on top of my other cells. Is there a way to prevent this from happening? Thanks, Andrew
  7. N

    Hiding Columns with Dynamic/Changing Tab Names

    PROBLEM: We need to hide several columns, on several sheets, based on a cell saying either TRUE or FALSE. But this is not so easy when the tab names (i.e. sheet names) can change, meaning that the formula for hiding these columns must be 'dynamic' also. In the spreadsheet we have formulas...
  8. Y

    Unhiding individual cells in real-time

    Currently I have a macro that goes line by line and determines if a specific cells's content needs to be hidden based on if certain cells in the spreadsheet are null. The macro works well but I would to see if the reverse could be checked in real-time. For instance, at the moment cell "I10" is...

Some videos you may like

This Week's Hot Topics

Top