hide rows based on a critera

[ccsmith]

According to the sample file there are many values in a range.
I want to use 2 buttons one for HIDE specific rows from a range A1:G11 one for UNHIDE all rows in the sheets.
The HIDE function could be based on the content of the column B just in range A1:G11.
If cells in column B in the specified range have value 0 the rows have to be hide.

[venkat1926]

click view in menubar and click tollbars in the toolbar window choose form. the form window opnes
choose two buttons and place it on the sheet1(data is in sheet1)

You have not said the cells in B column are 0 or blank. I have made provision for both.
assign to the two button the following macro respectively. change the text of the button.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[DonkeyOte]

Why not just use Auto Filter ?
(can't say I see the need for any VBA)