Button to hide/unhide rows with specific text

[Rick127]

Hi
I have inserted a button using the developer tab.

I want to click the button to hide/unhide rows containing specific text in column G

Can anyone help with the Macro for this?

It starts with Sub Button9_Click( )

Thanks!

 

[My Aswer Is This]

I think we need more specific details.
Like sheet name

And you said:
"Button to hide/unhide rows containing specific text in column G"
Nothing specific here

 

[NoSparks]

Based on the info given, maybe this will work.
But having no idea about anything else with the sheet, maybe not.

Sub Button9_Click()
    If Not ActiveSheet.AutoFilterMode Then
        Range("G:G").AutoFilter Field:=1, Criteria1:="<>" & "specific text"
    Else
        Range("G:G").AutoFilter
    End If
End Sub