Hello Im trying to find a solution to this problem.

I am Using Excel for Mac version 14.1.2
My Operating system is OSX 10.7.2

I am using visual basics to export a sheet to a PDF file.
ActiveSheet.ExportAsFixedFormat pbFixedFormatTypePDF, "pathandfilename.pdf"

This works perfectly every time until i print from excel using the file>print menu button or clicking apple-p. I don't even need to finish the print job. I can click cancel from the print window and it will still cause that function that worked perfectly every time to fail every time.

Any idea why this is happening? and how to fix it?