PrintOut line of code either gives an error, or saves a PDF file instead of printing. It doesn't work properly when the user has pressed the PDF button before pressing the PRINT button. It’s the PRINT button that sometimes causes a problem. On Mac 2016/2019/365, the PDF button works fine. I have a button in my workbook that allows the user to PRINT worksheets of their choice, and another that allows them to make a PDF of worksheets of their choice.īoth buttons work perfectly on Windows. I'm making an Excel workbook for both Windows & Mac.
