Excel Macro Hiding Rows with single predefined Condition

[VictorOpokin]

Dear experts, could you please kindly help with the following Excell challenge.
In my spreadsheet I need to have an option to automatically hide all the rows, where formula results in the "Hide" text. Just to highlight, all the cells are with formulas, not text.
What code can do this?

 

[VictorOpokin]

I think you want to set the OptionButton1 to true rather than select it.

Here’s some code to get you started.

ActiveSheet.OptionButton1.Value = True
ThisWorkbook.Sheets("Letter").Activate

Thank you a lot! should I just put it before the main code? I want to run both of them in one click.