Posted to microsoft.public.excel.programming

external usenet poster

Posts: 8

Print All Sheets-Select Printer First

Hello,

I am using the following code to print all sheets in a workbook, but want
the user to select a printer first. Not sure how to accomplish this. Any
help is very appreciated!

Application.ScreenUpdating = False

Sheets(Array("ACCOUNT SUMMARY", "VEHICLES", "DRIVERS", "AUTO LIMITS",
"GENERAL LIAB", "QUOTE")).PrintOut , , 1

Sheet1.PrintOut , , 1
Application.ScreenUpdating = True

Thanks,
Erica

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
Select Sheets to Print	CurlyDave	Excel Programming	11	September 16th 09 09:13 PM
members on my network printer not able to print to default printer	smeheut	Excel Discussion (Misc queries)	0	June 18th 07 06:42 PM
User select printer in print macro	sarah_tennessee	Excel Programming	0	April 7th 06 07:56 PM
User select printer in print macro	rocket0612[_11_]	Excel Programming	5	April 7th 06 07:49 AM
create a pause in print macro to allow user to select printer	Scott53	Excel Programming	1	September 7th 05 04:29 PM

All times are GMT +1. The time now is 09:13 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us