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

 

[Logit]

How to hide button control in VBA

CommandButton3.Visible = False

 

[leap out]

hi, logit
so I can put the same button of print when print userform

 

[Logit]

You should be able to place any number of buttons and use the command, specifying each button 3.

Be sure you make them visible again after printing.

 

[leap out]

sorry logit , I'm too late to reply you I tested this code but unfortunately it shows the buttons when I print userform
may you correct my mistake , please ?

 

[Logit]

Post your workbook to a cloud site so it can be downloaded. Post the link here.
No confidential data please.

 

[leap out]

i have in drop box i hope help
bs .xlsm

 

[Logit]

I am confused. Do you want to print the data located on the worksheet ?
If so, which worksheet ?

Or ... are you wanting to print the userform itself ?

 

[leap out]

Or ... are you wanting to print the userform itself ?

yes print userform when press button "print" hide all of buttons even button "print" , short word no buttons at all

 

[Logit]

Option Explicit

Private Sub CommandButton1_Click()
Dim RetStat
    CommandButton1.Visible = False
    RetStat = Application.Dialogs(xlDialogPrinterSetup).Show
    If RetStat Then Me.PrintForm
    Unload Me
End Sub