I would like to write a macro that prompts a UserForm to select which sheets/tabs to print from a workbook. This macro should identify the names of all the sheets in the file and display them in the userform with a checkbox next to each sheet, so the user can click which sheets he wants to print. Then there should be a Print button at the bottom.
The part I am hung up on is identifying/importing the names of the sheets in a given workbook. I would like this macro to work for any excel file.
