Hi
Two things please
1. I have a macro with the following code which prints specific sheets, this works ok. I would like a message to pop up with a YEs No answer, if No it does not print and stops the action and if Yes continue to print the specific pages.
Sub PrintingPEFC()
Sheets("SawnPivot").PrintOut Copies:=1
Sheets("ArbordeckPivot").PrintOut Copies:=1
Sheets("BespokePivot").PrintOut Copies:=1
Sheets("StockPivot").PrintOut Copies:=1
End Sub
Could someone please advise this can be achieved. I will Google and try some things out in the meantime.
2. Also when testing such things is there a way to print to screen instead of printer to save on paper?
Thanks
Two things please
1. I have a macro with the following code which prints specific sheets, this works ok. I would like a message to pop up with a YEs No answer, if No it does not print and stops the action and if Yes continue to print the specific pages.
Sub PrintingPEFC()
Sheets("SawnPivot").PrintOut Copies:=1
Sheets("ArbordeckPivot").PrintOut Copies:=1
Sheets("BespokePivot").PrintOut Copies:=1
Sheets("StockPivot").PrintOut Copies:=1
End Sub
Could someone please advise this can be achieved. I will Google and try some things out in the meantime.
2. Also when testing such things is there a way to print to screen instead of printer to save on paper?
Thanks