New to VBA so this may be a bit of a complex question
I have a workbook with many workseets (about 27) that users may want to print the full report (all worksheets) or just selected worksheets.
Can anyone suggest a user friendly way of doing this other than selecting/grouping the sheets then print active sheets.
Ideally it would be cool to create a "Print" command button that created a list of all worksheets with an option button (like on the control toolbar) where the text for the each button was the name of a worksheet. The user would click on the ones to be printed, or a "print all" button. The 27 worksheets keep the same name, but some additional worksheets may be added from time to time, so the list need to be dynamic.
Any suggestions would be appreciated.
Bookmarks