Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Print & Close Buttons in Print Preview grayed-out when '07 script
I wrote a little script that imports and then manipulates data on a number of
worksheets and then sorts and formats that data in preparation for printing. It then brings up the report in a print preview window and waits for the user to either print or close and then moves on to a second report and third and fourth stopping at each for the user to decide to print or close the preview. This worked like a charm in 2003 and previous versions but when we moved to 2007 it has a rather major problem--namely the bottons to print and to close are grayed out. What's changed and what do I need to change to fix this? Your help is greatly apprecaited! Thanks in advance! In case it's helpful, I use ActiveWindow.SelectedSheets.PrintPreview to print preview. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
have toggle buttons but everytime print preview buttons move | Excel Discussion (Misc queries) | |||
Print Preview Zoom grayed out Excel 2003 | Excel Discussion (Misc queries) | |||
VBA buttons shift around when using Print/Print Preview | Excel Programming | |||
how to close print preview | Excel Worksheet Functions | |||
Macro buttons tiled after print / print preview | Excel Programming |