G
Guest
I am using the following code which hides the user form during Print Preview.
How do I incorporate code to return (Unhide?) the UserForm if I click close
on the preview window?
Private Sub cmdPrintPreview_Click()
Sheet1.PageSetup.PrintArea = "A1:U13"
UserForm1.Hide
Application.Dialogs(xlDialogPrintPreview).Show
End Sub
Thanks
Demot
How do I incorporate code to return (Unhide?) the UserForm if I click close
on the preview window?
Private Sub cmdPrintPreview_Click()
Sheet1.PageSetup.PrintArea = "A1:U13"
UserForm1.Hide
Application.Dialogs(xlDialogPrintPreview).Show
End Sub
Thanks
Demot