I am using an userForm to perform various tasks (applying filters, sorts, etc)
I have a command button to take the current view and show the Print Preview
However, I get not figure out hold to close the print preview through VBA. I have tried closing the active window, ViewApply to another view, none work.Code:
Private Sub cmdPrint_Click ()
FilePrintPreview
End Sub
I would appreciate any help. Thanks
AM