I use the statement ActiveWorkbook.PrintPreview in a Excel 2016 VBA Code. When running the Code the preview of the worksheet is popping up correctly, but the buttons Print, Close etc. are disabled so I can not start the printing. If I step through the Code statement by statement, the buttons are enabled. Is there a problem with focus? The problem is only related to Excel 2016, not to Excel 2010.What can I do to unlock the buttons?
I have tested with 2016 and it works fine for me
Are you referring to these buttons?
PrintPreview.jpg
Please
- post your macro in full
- confirm that the buttons are available if you click on Print Preview (without VBA)
thanks
Last edited by kev_; 10-30-2017 at 12:12 PM.
Click *Add Reputation to thank those who helped you. Ask if anything is not clear
I have done some more testing with Excel 2016. The problem occures when previewing from an external workbook (another book than where the code is). I walk around the problem by copying the data from the external book to the book with the code, then previewing works. Excel 2010 can preview from an external workbook.
Which version of Windows are you using?
(I use Windows10 and I cannot replicate your problem)
Another 2 ways to print preview the active sheet
Try them - but I do not expect either to fix your problem
To close the print preview window (when X greyed out) try {ALT} F4
Please Login or Register to view this content.
To print after closing print preview try {CTRL} P
I use Windows 10. But with the walk around that I described in my last Post, my code works and I am happy. Thank you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks