Hide rows - VBA

Hi,

Anyone know how I can have the enclosed file so that when I add an x anywhere in a range of cells say A5 down to A24 and then run a VBA code then this rows with the x are hidden.

I know I can run a filter or sort to isolate but I want to have a 'hide' and a 'unhide' button to do this.

Any help appreciated.

G

So when you enter an X in column A you want the row you've entered it on to hide?

The hide/unhide button would unhide all rows and hide those with an X?

BSB

Assign this code to the rectangle.

Please Login or Register  to view this content.

Perfect, many thanks, just what I was looking for:

Hi,

Anyone know how I can edit the code below so that when I add an x anywhere in a range of cells across columns say A1:S1
and then using VBA code then these columns with the x are hidden, then assign the code to a shape so that there is a 'hide' and a 'unhide' button to do this.

Any help appreciated.

G