print targeted sheets from main sheet

[AnthonyMinnaar]

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.

 

[AnthonyMinnaar]

a photo to make it a bit more understandable. the red arrow shows the button that needs to print the sheet it points to.

 

[AnthonyMinnaar]

fixed it!