Good day to all,
I would like to know if I can print a hidden worksheet called Price List (sheet 2) that has a dynamic range? I have three spreadsheets called Costing, Pricing and Do Not Delete. Pricing and Do Not Delete are hidden and protected worksheets. I would like to be able to create a Macro that will print only the "Pricing" worksheet and keep it hidden. This sheet is also dynamic in range based upon input from "Costing". Last record in $A:$A over to $L:$L
Can this be done. I see where I can print hidden worksheets and dynamic, but can they be combined and the view to change to the user?