hiding Command Button

[aka_krakur]

Is there a way to hide the command button after it's already done what it needs to do. For instance, CommandButton1 just runs a macro to format a Worksheet. After the worksheet is formatted, the button now hovers over some of the data. I know how to set the option so it doesn't print; but as far as on the screen, can I hide it by a simple code at the end of the macro?

 

[aka_krakur]

Well, thanks everyone for your help. I ended up using some of Dufus and Dave's combined. Here's what it looks like and it worked!!!

Private Sub Worksheet_Change(ByVal Target As Range)
Select Case Range("A1") = "Shipped Qty"
    Case True
        Sheets("ShippedQty-SummarybyYr").CommandButton1.Visible = xlVisible
    Case False
        Sheets("ShippedQty-SummarybyYr").CommandButton1.Visible = xlHidden
End Select
End Sub
Private Sub CommandButton1_Click()
If Sheets("ShippedQty-SummarybyYr").Range("A1") = "" Then
Sheets("ShippedQty-SummarybyYr").CommandButton1.Visible = xlHidden
MsgBox "You must copy/paste data from Viper Drill Down 1st!!"

Else
If Sheets("ShippedQty-SummarybyYr").Range("A1") = "Shipped Qty" Then
Sheets("ShippedQty-SummarybyYr").CommandButton1.Visible = xlVisible