hide buttons on userform when print it

[leap out]

hello
I have userform name's "frmprint" and I have many buttons (search,print , exit) what I would when print the userform hide any button
thanks in advance

 

[leap out]

nice code , could you amend the code to make it directly print without choose the printer
thanks again

 

[mohadin]

If I may

Private Sub CommandButton6_Click()
    Dim RetStat
    CommandButton6.Visible = False
    Me.PrintForm
    Unload Me
End Sub

 

[leap out]

thanks mohadin and logit much appreciate that just notice about mohadin's code you do not need declarer variable

    Dim RetStat

 

[mohadin]

All the thanks should go to logit,
Hi did the hard job
Thank you

 

[Logit]

You are welcome. Glad you have an answer.