Printing from tick boxes

[DrJimmy]

Hi, I want to be able to have a spreadsheet that has multiple worksheets on, and then have a summary sheet that has tick boxes relating to the names of the worksheets.

I then want to be able to have a macro that will print out the relevant worksheets that have the tick box as true - is this possible?

Cheers

 

[Call_Me_Sam]

Hi, I want to be able to have a spreadsheet that has multiple worksheets on, and then have a summary sheet that has tick boxes relating to the names of the worksheets.

I then want to be able to have a macro that will print out the relevant worksheets that have the tick box as true - is this possible?

Cheers

DrJ, i believe this to be possible. Create the Summary sheet with checkboxes. Name them how you see fit. Create a commandbutton and add this code

Private Sub CommandButton1_Click()
If CheckBox1.Value = True Then
    Sheet2.PrintOut Copies:=1, Collate:=True
End If
If CheckBox2.Value = True Then
    Sheet3.PrintOut Copies:=1, Collate:=True
End If
End Sub

Change the checkbox names accordingly (and commandbutton if necessary). The vba uses the Sheets CodeNames so you may need to add

[COLOR=red]Sheets("[I]name[/I]")[/COLOR].PrintOut

Instead of the Sheet2 or Sheet3. Hope this is what you wanted.

 

[DrJimmy]

That works fine.

Cheers