Print button for hidden sheet VBA

[bakarken]

I have a print button setup in sheet1 which is a form control attached to a macro that will printpreview sheet2. It works just fine when the button is pressed but only if sheet2 remains unhidden.

if possible I'd like for this button to work even if sheet2 is hidden and will not u hide it when pressed . Is this possible? Thanks

 

[Norie]

You can't print or print preview a hidden sheet, try this.

    Sheet2.Visible = True
    
    Sheet2.PrintPreview
    
    Sheet2.Visible = False