Need help creating a button to hide rows based on value of cell.

I am faced with a situation where I need the option to hide many rows with a button. I am unsure how to write the code to trigger a macro that would scan a column and depending on the value detected in each row, that row would be hidden.

IE: it scans Column D for a check-mark or dash. If Row 2 is a dash it is hidden, however if Row 3 is a check mark, it is not.
Additionally, I am not clear on how to create a button that would activate this macro, although I'm sure it is the easy part.

I have attached a dummy workbook for reference to clarify what I am asking help for.

Any help would be greatly appreciated!

Thank you

Put the following code in a module and try it.

Please Login or Register  to view this content.

Elio Fernandes