Figure 4. This works best when the printer has a page size that matches the screen sizes; if not, it is still possible to print all the pages. How to Print Specific Sheets Using VBA Macro in Excel (5 Ways) Oct 29, 2023 — How to print specific sheets using VBA macro in Excel (5 Ways). Here I am printing three sheets with the sheet number 1, 2 and 3. Printout method (Excel) — Microsoft Learn (1, 2, 3, 3, 5) (See Figure 5.) Printing 3 sheets with sheet number 1, 2 and 3 using VBA Macro | Excel Tips Dec 30, 2023 — How to print 3 sheets with sheet number 1, 2 and 3 using VBA macro in Excel. (1, 2, 3) using vba_open_file() function. Then, by using the same steps to take the three other sheets, I print the complete sheet that I need (sheet number 5) with the option to print. I also print the same sheets without the option to print. The other sheets will still print with the option to print, but those sheets require additional steps. How to Print Specific Sheets Using VBA Macro in Excel (6 Ways) May 25, 2023 — How to print specific sheets using VBA macro in Excel. (1, 2, 3, 5, 6) (See Figure 6.) Printing selected pages in Microsoft Excel (vba_open_file_function) Jun 28, 2023 — Prints selected pages by using the vba_open_file-function. You can also set these worksheet options manually — in the Excel Options dialog box. (See Figure 7) Figure 8. (Click on image to enlarge.) VBA Macro for Printing Workbooks with Specific Sheets Feb 9, 2023 — VBA Macro for printer with specific pages or with sheets in specific sheets. I use this VBA macro to use the macro page function to print the pages in a specified sheet only. When using the macro page function, I am able to print the pages in sheets with name “A”– “B” or with name “C”– “D”. (See Figure 9.) Note. If you need to print several pages in a specific sheet, only select the desired pages from the list box in the drop-down window (see screenshot below). Figure 9.