Posted to microsoft.public.excel.programming

Code Numpty Code Numpty is offline

external usenet poster

Posts: 94

Print specific range but user to select printer

Hi, I have the following in one of my macros to print to the default printer.

Worksheets("Disinfections").Range("pen_list").Prin tOut

How do I change this so that the print dialog box pops up to allow the user
to select the printer and page size?

Happy New Year! (nearly)

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
Trying to select a specific range based on the time value of user form input	Jitranijam	New Users to Excel	8	November 15th 06 12:52 AM
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
My First User Form - How to Select Range(s) and Print	Bruce Roberson[_2_]	Excel Programming	3	July 25th 03 03:09 AM

All times are GMT +1. The time now is 08:34 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us