-
Personally I would create a simple userform with 10 checkboxes, captioned from the sheet names e.g.
[VBA]Private Sub UserForm_Initialize()
For i = 1 To 10
Controls("Checkbox" & i).Caption = Sheets(i).Name
Next
End Sub
[/VBA]
and run the print from a button.
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules