When using ActiveSheet.PrintPreview in my VBA code in Excel 2007, there is no close button or print option buttons available when then preview comes up. Is there a fix or method to get around this problem. Any suggestions greatly appreciated. Thank you.