hiding cells

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...

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...

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...

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...

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

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

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...

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...