Hi,
I did some search and couldnt get the help I needed.
The following code attempt is in a userform with one print button, one cancel button and six checkboxes refering to which sheets that are needed to print.
Please help, THANKS
![]()
private sub cancelprint_click() unload me end private sub printdeal_click() application screenupdating = False if CheckBox1.value = True then sheets("dealsheet").printout copies:= 1 if CheckBox2.value = True then sheets("trade").printout copies:= 2 if CheckBox3.value = True then sheets("payoff").printout copies:= 1 if CheckBox4.value = True then sheets("stips").printout copies:= 1 if CheckBox5.value = True then sheets("businessmgr").printout copies:= 1 if CheckBox6.value = True then sheets("cc").printout copies:= 1 application screenupdating = False end sub
Bookmarks