print macro

[alanoreilly]

as a part of a print macro I want to let users decide which sheets to print using a form...

on pressing a button I want a form to pop up with check boxes (for example) beside each sheet name....the macro then prints tehw selected sheets........is this possible???

Thanks,
Alan

 

[jimboy]

Add the checkboxes to the form and add a command button with this code;

Private Sub CommandButton1_Click()
If UserForm1.CheckBox1 = True Then Sheets("Sheet1").PrintOut
If UserForm1.CheckBox2 = True Then Sheets("Sheet2").PrintOut
If UserForm1.CheckBox3 = True Then Sheets("Sheet3").PrintOut
'sets checkboxes back to false (unticked)
UserForm1.CheckBox1 = False
UserForm1.CheckBox2 = False
UserForm1.CheckBox3 = False
UserForm1.Hide
End Sub

 

[alanoreilly]

thanks for that, I'll give it a go

 

[alanoreilly]

that works perfectly, thanks again

Alan