| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
changing Print Preview default value
hello to all
I have shown a code fragment that shows a report in Print preview mode. With Worksheets("PrintRpts") .PrintOut copies:=PrintNumber, preview:=PrntPrev End With My sub is used to show many such previews in sequence. Typically I give a quick inspection, then Print the copy. The preview displays properly, but the 'zoom' button is always highlighted by default. How can I use code to have the 'Print...' button highlighted by default. Giselle |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Changing Default Print Quantity | Excel Worksheet Functions | |||
| Changing Default Number of Copies to Print | Excel Discussion (Misc queries) | |||
| Print and Print Preview Graphic Moving Resizing 2007/2003 | Excel Discussion (Misc queries) | |||
| print preview v page break preview | Excel Discussion (Misc queries) | |||
| Changing the default print settings in Excel | Excel Programming | |||
![Giselle[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
