(SOLVED) Hiding rows based on a cell value that comes from a formula

Dear all,

I am quite new to VBA but i am a fast learner and hope some of you can help me with the following:
I have searched dozens of forums and theads, but i cant seem to find an answer.

In my file I am trying to hide Rows (33:41) based on a cell [G4] value (HIDE,UNHIDE) or (1,2) doesn't really matter which one.

Now i have used the following code:

Private Sub Worksheet_Change(ByVal Target As Range)
If Range("I4").Value = "HIDE" Then
Rows("33:41").EntireRow.Hidden = True
ElseIf Range("I4").Value = "UNHIDE" Then
Rows("33:41").EntireRow.Hidden = False

End If
End Sub¸

The problem that I have is that it works as long as I manually type in the value, but this value is generated by a formula therefor nothing happens.

Hope you guys understand what i am asking

Thanks in advance !