Print Preview Specific Hidden Worksheet

[angelmaine4ever]

Hi,

Would any one know the vba code to Print Preview Specific Hidden Worksheet?

Thanks!

 

[Jaafar Tribak]

Hi,

Would any one know the vba code to Print Preview Specific Hidden Worksheet?

Thanks!

Maybe something along these lines :

Sub test()

    On Error GoTo errHandler
    With Sheet1
        Application.ScreenUpdating = False
        .Visible = xlSheetVisible
        .PrintPreview
errHandler:
        .Visible = xlSheetVeryHidden
    End With

End Sub

 

[Tony_Y]

Hi,

I know this is an old post but I just wanted people to know this code works as I have used it.

Many thanks

Tony