![]() |
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