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