ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Can't Click Anything (https://www.excelbanter.com/excel-programming/411186-cant-click-anything.html)

Mike H.

Can't Click Anything
 
Frequently I will display a report in print-preview mode for users to either
close or print. But sometimes none of the buttons on the screen except the
Red X in the upper right-hand corner are available. I often turn things off
so before I display a print preview screen I do this:
Application.Cursor = xlDefault
Application.ScreenUpdating = True
Application.EnableEvents = True
ActiveWindow.SelectedSheets.PrintPreview
Application.ScreenUpdating = False
Application.Cursor = xlWait
Application.EnableEvents = False
Why would I sometimes not be able to do anything with the previewed screen?
Ideas?




All times are GMT +1. The time now is 10:23 PM.

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