Print different worksheet without changing sheets

[ddowler]

Hi, I have a workbook with several sheets. Sheet 1 has order details and sheet 2 has delivery note. Details are only input on the order details sheet and the delivery sheet is auto. I want to know if it is possible that while on the order details sheet and you print that you can set excel to print only the delivery sheet without changing to it?

Many thanks in advance,

 

[buxtongt]

This can be done with a macro assigned to a custom button, either in the toolbar/ribbon or on the sheet itself. Make sure you set

application.screenupdating=false

and the user will never see the sheet change on the screen.

 

[ddowler]

Thanks, but is there a way without macros. Because of security reasons I don't like to disable the macro pop up when opening the workbook and people panic and say no, then the macro won't work.