Compile Error : Invalid outside procedure is popped

Good Afternoon, i'm new in VBA but need to hide some rows based on value in specific cell. i already made this code but if i run the code using alt+f8
Compile Error : Invalid outside procedure is popped. Can u help me ? thanks

Sub Contoh11_1()
If Range("E14").Value = Range("E170") Then

'Menyembunyikan baris

Rows("39:40").Hidden = True

Else
'Menampilkan baris

Rows("39:40").Hidden = False

End If


End Sub

You can try this code:

Please Login or Register  to view this content.

Can i use this code ? or i need to change something ?

Yes, of course. You can also change the Target.Value to Cells(1,"E") if you want to be specific. Target.Value if you wanted to input value to any cell.