Hiding rows based on cell contents

[andrewb90]

I need to get a formula or a piece of code that looks at cell D3 and if the number is not 5 then rows 800 & 810 will be hidden.

Can anybody help with this?

Many Thanks,

Andrew

 

[Rick Rothstein]

By the way, would you happen to know how to have a macro button open up a gmail and compose a message?

No, I'm sorry, but that is something I have never had to work with before. My suggestion would be to create a new thread with that specific question as opposed to hoping someone who knows will see it here.