Show / activate emailing button when needed

[Xemil]

I am teaching myself VBA and am not very familiar with it. I could use some help with my problem:
I have got a button (which type to choose? I used Command button becouse of the code I found) which sends email with the attached active spreadsheet. I used code

Please Login or Register  to view this content.

It seems to be working well. The next step would be to have this button deactivated (or hidden) when A15 cell is blank. If the A15 cell is populated – the button with the macro (above) should be active (or visible). I am thinking about using found on the forum code:

Please Login or Register  to view this content.

but it hasn’t worked work for me so far. Maybe it’s not the proper one? Perhaps I am pasting the code in a wrong place? Any ideas (step by step) what code to use and how/where to place it, please?

I found there are other VBA codes for sending emails. Mine seems to be quite tight. Is everything okay with it?

[wotadude]

You ideally will need to use the Change event not selection change
event, and validate against A15 not A1.

Using a forms type control button (name/change as required - currently "MyButtonName")

Please Login or Register  to view this content.