I recently set-up a jet report (I'm new to using Jet) and I created a simple excel macro to print various portions of the file. When I run the macro, the print preview screen comes up but it doesn't allow me to print (I lose the print preview tab). Then when I escape out of the preview all my Excel ribbon tabs are gone as well (the 'File' tab is the only thing remaining on the ribbon). The excel macro is using the following code:
Application.Goto Reference:="onepage"
Selection.PrintOut Copies:=1, Preview:=True, Collate:=True
Any help/insight would be appreciated.
Thank You,
0 comments
Please sign in to leave a comment.