Am pretty new to vba.

Row 14 will be hidden by default.
Am trying to automatically trigger the unhiding of row 14 based on the value in cell E13, which can have only Yes or No or can be blank.

So if cell E13 is blank or "Yes" then do nothing .. i.e. don't unhide row 14
But if cell E13 is "No", then unhide row 14.

I want the macro to trigger automatically, based on user entry in cell E13. (without a button to manually trigger).

I have searched other answers and have tried to adapt the closest ones to my problem but no success.

Any help - specially with sample code -will be appreciated.

thanks