Hide or show Rows with IF condition

[geekaysys]

Hi, I would like to hide Row 16:24 if D14="No"

No need to Hide if D14 = 'Yes'

D14 yes/no is from Drop down list.

[oeldere]

With this recorded macro.

Sub Hide_Oeldere()

If Range("d14").Text = "yes" Then
    Rows("16:24").Select
    Selection.EntireRow.Hidden = True
    
Else
If Range("d14").Text = "no" Then
    Rows("16:24").Select
    Selection.EntireRow.Hidden = False
    
    Range("D14").Select
End If

End If

End Sub

[geekaysys]

Hello, It is not working sir, Actually I have other macros also working with that.

the 2nd part is OK. that is the number of Director and Shareholders (i need to change the cell location)

Also I want, the sheet also to be HIDE according to the number of director or shareholder.

Thank youl