| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I create a click on + symbol to open a root and click on -. | Excel Discussion (Misc queries) | |||
| Disabling click and right-click on the Picture I inserted in an Excel document | Excel Worksheet Functions | |||
| Scrollbar single click acts like click and hold | Excel Programming | |||
| Click on graph bar to execute a double-click in a pivot table cell | Charts and Charting in Excel | |||
| Mouse Over Graph, Capture Information on Click(Double Click) | Excel Programming | |||
Linear Mode
