ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Not ScreenUpdating with PrintOut Property (https://www.excelbanter.com/excel-programming/405711-not-screenupdating-printout-property.html)

Edd[_2_]

Not ScreenUpdating with PrintOut Property
 
Hello:

I use ActiveWindow.SelectedSheets.PrintOut in my code, and this code
seemingly freezes my code in-action from being viewed on the screen. It
reacts similarly to when Application.ScreenUpdating is set to false (and it
is not). When I press on the Print smarticon, all works as intended. How can
I disable the screen from freezing when I use
ActiveWindow.SelectedSheets.PrintOut or do you have any suggestive
work-arounds?

Thanks,


All times are GMT +1. The time now is 06:07 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com