Print UserForm for multi-sheet printing
Closed
Hello,
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.
Any help would be appreciated.
-Brian
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.
Any help would be appreciated.
-Brian
Related:
- Print UserForm for multi-sheet printing
- Hp universal print driver - Download - Drivers
- How to stop printer from printing - Guide
- Google sheet right to left - Guide
- Windows network commands cheat sheet - Guide
- How to print from mobile without wifi printer - Guide