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

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top