I have a user form with checkboxes, one for each sheet in the workbook. The user selects the appropriate checkboxes then clicks a command button that prints selected sheets.
How do I build the array so it holds only the selected sheets?
I'm using this to print the sheets:
Sheets(Array(sh1, sh2, sh3)).Select
ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True
sh1, sh2 hold the sheet names:
If CheckBox1.Value = True Then
sh1 = "Control Panel"
End If
I hope this is enough information, thanks for helping me.
Excel 2000
Bookmarks