JohnZ1156
Board Regular
- Joined
- Apr 10, 2021
- Messages
- 180
- Office Version
- 2021
- Platform
- Windows
I have a macro assigned to a button to print a specific area of my worksheet.
Here is the script:
If the printout is one page, it shows me a preview before I press the print button in the upper left corner of the screen.
If the printout is more than one page, I can see the first page in preview, however, even if I try to scroll down using the shaded bar on the right of the screen, it still only shows me the first page.
I know I'm missing something in my macro.
Thanks for your help in advance.
John
Here is the script:
VBA Code:
ActiveWindow.SelectedSheets.PrintOut Copies:=1, Preview:=True, Collate:=True, _
IgnorePrintAreas:=False
Range("A1").Select
If the printout is one page, it shows me a preview before I press the print button in the upper left corner of the screen.
If the printout is more than one page, I can see the first page in preview, however, even if I try to scroll down using the shaded bar on the right of the screen, it still only shows me the first page.
I know I'm missing something in my macro.
Thanks for your help in advance.
John