Posted to microsoft.public.excel.programming

James Cornthwaite James Cornthwaite is offline

external usenet poster

Posts: 53

ActiveWindow.SelectedSheets.PrintOut ?

Hi,

Does anybody know how "ActiveWindow.SelectedSheets.PrintOut" can changed to
make all selected worksheets be sent to the printer as one job rather than
several jobs ?

The rationale being its used in a macro where all pages must be printed
together without the risk of other peoples (printer on busy network) jobs
being placed in between or is it not possible?

Many thanks
James

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Excel.ActiveWindow Is Excel.ActiveWindow Returns False	Neal Andrews	Excel Programming	1	October 26th 06 11:10 AM
ActiveWindow VBA problem	Tomasz Klim[_2_]	Excel Programming	2	June 11th 06 11:04 PM
ActiveWindow.SelectedSheets.PrintOut	excel-lent	Excel Programming	4	June 15th 05 03:48 PM
ActiveWindow.SelectedSheets.PrintPreview	HelpMe	Excel Programming	0	November 17th 04 03:53 PM
Using ActiveWindow.PointsToScreenPixelsY	Pancho	Excel Programming	5	February 7th 04 11:23 PM

All times are GMT +1. The time now is 11:16 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us