how to select a print area on a hidden sheet

[dan2014]

hi
can anyone help on setting a print area on a hidden sheet for a range
sheet name is Names and the range would be A1:K10
this would then let me choose which printer to send the selected range to.
This is what i would like to use but on a hidden sheet.
the reason i need to be able to select a printer is that there are several printers on the network.

Please Login or Register  to view this content.

[YasserKhalil]

Try this

Please Login or Register  to view this content.

[dan2014]

Hi
thank you so much that works perfect.