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

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

Sheets("name").PrintOut

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

That works fine.

Cheers