how to print userform without showing button

[rharri1972]

I previously asked what I may be doing wrong to get userform to print with button click.
I have since discovered it was the computer to printer that was the issue.

Now that :

Private Sub CommandButton1_Click()
UserForm3.PrintForm
End Sub

is working.... how do i keep the button's image from printing as well.

I only want the data that is pertinent to the customer order to print.

In reality, everything can print other than the button.

I've read on google that it may be the .PrintForm that is causing this... but i can't find any other ways to have it print the userform.

Any help?

 

[Jaafar Tribak]

How about setting the Visible Property of the commandButton to False before printing and setting it back to True afterwards ?

 

[rharri1972]

How about setting the Visible Property of the commandButton to False before printing and setting it back to True afterwards ?

Jaafar thank you! works perfect