Hi,
I have a workbook which I have been working on for 5 years. Up until now I have used print and preview buttons from specific informational gathering pages. Print pages are different than the pages where the information is gathered, and other than previewing or printing, I do not allow the user access to these sheets.
I am about to add a custom toolbar to my workbook, and would like to know if it is possible to print a different sheet and then return to the sheet you were at, and if so, could you modify my example of some code so that that would be possible
Code
Sub Print_DH_Info()
With Assistant
.Animation = msoAnimationPrinting
End With
Application.ScreenUpdating = False
Sheets("DH").Select
ActiveSheet.PageSetup.PrintArea = "$G$1:$P$45"
dlganswer = Application.Dialogs(xlDialogPrint).Show
Sheets("info").Select 'currently returns to this page
Application.ScreenUpdating = True
End Sub
Display More
Thanks very much for your help.