Macro for hiding rows

**Cunner** · 03-02-2010, 04:38 AM

Hello everyone,

I am trying to build an Excel-timesheet. For this timesheet I want to show just the weeks that aren't filled out and the current week.

Please have a look at the attached example sheet, it will make it clearer.

I was thinking about having a macro or function that allows me to enter something like:

"if the cell in the same row, column B equals "Hours" AND cells D"rowindex":J"rowindex" are NOTEQUAL "", then hide this row and the row above"

and also:

"hide all future weeks"

It doesn't necessarily have to be a macro or something, if anyone has a better idea, go ahead.
Thx alot in advance and
kind regards.

**MarMo** · 03-02-2010, 08:02 AM

Hi Cunner ,

Could you explain this a little simpler pls.
I understand from your post that when a row is not filled in completely from column "D" till "J" then
the active row and the row above should be hidden.

in your example the macro or function should hide rows 6 and 7 if cells D7,E7,F7,G7,H7,I7,J7 have no data.
Is this correct ?

**Cunner** · 03-02-2010, 08:57 PM

Originally Posted by MarMo

Hi Cunner ,

Could you explain this a little simpler pls.
I understand from your post that when a row is not filled in completely from column "D" till "J" then
the active row and the row above should be hidden.

in your example the macro or function should hide rows 6 and 7 if cells D7,E7,F7,G7,H7,I7,J7 have no data.
Is this correct ?

Thanks for your interest.

Let me start by stating the objective:
right now the sheet just shows all the weeks. This is s a little too much information on the sheet. So I want the users to see just the rows that they still need to fill in (and the respective Date-row), which means that they shall see all past weeks that they haven't filled out yet completely and the current week.
So the macro (or whatever) shall hide all weeks that are completely filled out and all future weeks. That means, if we have Wednesday today, the week starting the next Monday shall be hidden.

I hope that makes it clearer.

Thanks a lot

**MarMo** · 03-03-2010, 08:09 AM

Hello Cunner ,
I've attached a modified file with 2 buttons.(hide and unhide rows)
the "unhide all" button unhides all rows in the worksheet.

the "Hide " button will hide all rows where ALL cells for the Hours are completed.
I still need to find out how to determine how to match the current day with the following monday to hide these rows as well.
Perhaps you could analyze this code first to see if it meets your demand.

**Cunner** · 03-04-2010, 09:55 PM

Thanks, this is a great first step to make the sheet more workable.
As I have no idea about VBA I might be completely of, but might there be a way to make the macro look for =TODAY() and then just hide all rows below the Hours row?

And a more general thing:
If I use the macro for several worksheets, do I always have to change the name of the worksheet in the macro or is there a general placeholder that references the active worksheet?