Hi
I have a very simple macro that prints the sheet I am working on. I also have a more complex macro that saves a copy of my sheet as a pdf.
The problem is that if I click the macro that saves (prints) to pdf and then click the print macro, it tries to save as a pdf again.
How can I make my print macro force excel to print to my local default printer and avoid this from happening?
At the moment, my print macro is:
Sub PrintCopy()
ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True
End Sub
Many Thanks
Chris Mayer
Bookmarks