Can't Click Anything

M

Mike H.

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel -> Word (Textbox Find/Replace) 0
Cursor change during code execution 2
Addin not allowing thisworkbook.save in before save event 3
Speed of Execution 3
Get last line in a CSV file for import 2
Worksheet Change Event macro fails intermittently 6
Suppressing a screen 4
Print A For (docm), Send Email Attachment And Close For Without Saving 2

Top