AnthonyMinnaar
New Member
- Joined
- Aug 25, 2020
- Messages
- 28
- Office Version
- 2013
- Platform
- Windows
Hello folks,
I tried to make a button on a main sheet to print another sheet, but I cant get it working. as an alternative I made a button on the sheet that needs to be printed, and that seems to work (this is what I used to do that:
ActiveWindow.SelectedSheets.PrintOut ActivePrinter:="", copies:=1, collate:=True)
Is there a way to print another sheet with button on the main sheet? what should I replace "ActiveWindow.SelectedSheets" with to target a certain sheet?
thanks in advance,
Anthony.
I tried to make a button on a main sheet to print another sheet, but I cant get it working. as an alternative I made a button on the sheet that needs to be printed, and that seems to work (this is what I used to do that:
ActiveWindow.SelectedSheets.PrintOut ActivePrinter:="", copies:=1, collate:=True)
Is there a way to print another sheet with button on the main sheet? what should I replace "ActiveWindow.SelectedSheets" with to target a certain sheet?
thanks in advance,
Anthony.