Click to Hide the Clicked commandbutton1? Possible

[obaid_457]

I have a user form A5 Size and there is commandbutton1 in right down corner of user form
whenever I print user from on page the commandbutton1 also print on page

is there any Code when I click commandbutton1 to print the page. then the button should hide???

and not be print on page

 

[mikerickson]

Something like this should work.

Private Sub CommandButton1_Click()
    CommandButton1.Visible = False
    Me.Repaint
    Application.ScreenUpdating = True
    ' print routine
    CommandButton1.Visible = True
End Sub

 

[obaid_457]

I just Change a little and I got what I want
Thanks dear

Private Sub CommandButton1_Click()
    CommandButton1.Visible = False
    UserForm1.PrintForm
End Sub