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 
Sub SendIt()
    Application.Dialogs(xlDialogSendMail).Show arg1:="eiwaszki@its.jnj.com", _
                      arg2:="ESC-CS Level 2 High / Low"
End Sub
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:
Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)
If Range("A1") = "" Then
CommandButton1.Visible = False
Else
CommandButton1.Visible = True
End If
End Sub
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?