Hide rows with cell value = 0

I want to hide rows that have a cell value of zero. I am an extreme beginner with VBA.

Hi could you be a little more specific. Where are we supposed to find the 0 values? It would be great if you could attach a copy of your workbook.

For example this code will do what you are asking for if the empty cells are in column "A"

Please Login or Register  to view this content.

Here is the workbook I am using. The specific sheet is Bulk Plant Load-Out. I want the row to hide if the value in column b=0. I would also like a toggle button to unhide rows.
Thanks for your help.

Hi marine,

See if this works for you. Here is the code I used.

For the macro

Please Login or Register  to view this content.

For the Toggle button

Please Login or Register  to view this content.

And the attachment

Surface - Proposal.xls