Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Giving FOCUS to Print Preview
To any Programmer,
Help, I used to be able to call Print Preview in code, and immediately upon display of the preview window I could use the scroll-wheel on the mouse to start advancing thru the 'preview' ... Somewhere along the line (not sure if it was the change to Office2000, I have to now select ANY button (once) on the Preview tab to 'allow' the scroll-wheel to function as it used to - (Not sure why 'focus' is not given to the Preview window). Once I select, for example "NEXT", then the scroll-wheel works. Any ideas on how to give focus to PREVIEW? ... I'm currently using code similar to the following: Function PageToPrintOrView(iStart As Integer, iFinish As Integer, _ iPrintOrView As Integer) '------------------------------------------ ' Routine receives: ' iStart Value: Start Page # ' iFinish Value: Finish Page # ' iPrintOrView Value: 0 = Print / 1 = PrintPreview '------------------------------------------ ActiveSheet.Select With ActiveSheet .PrintOut From:=iStart, To:=iFinish, Preview:=iPrintOrView, _ Copies:=1, Collate:=True End With End Function ANY HELP WOULD BE GREATLY APPRECIATED ... JimP |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Print and Print Preview Graphic Moving Resizing 2007/2003 | Excel Discussion (Misc queries) | |||
print preview v page break preview | Excel Discussion (Misc queries) | |||
cell borders that I create dont show on print preview or print | Excel Discussion (Misc queries) | |||
Why does macro speed slow after Excel Print or Print Preview? | Excel Programming | |||
Giving focus to a particular sheet | Excel Programming |