Macro to Select Pages & Show Print

A

Ad

Hi,

I'm trying to get a Macro that will allow me to select
multiple worksheets then bring up the Print Dialogue box
(So i can select printer). The selection of worksheets
works fine when recording but to bring up the print
dialog box is a problem as I can only complete recording
when the Okay button on the print box is
pressed...therefore when I run the macro it goes straight
to print and doesn't allow me to select/change the
printer..

Any help would be great!!
 
P

Paul B

Ad, this should do it Application.Dialogs(xlDialogPrint).Show
--
Paul B
Always backup your data before trying something new
Using Excel 2000 & 97
Please post any response to the newsgroups so others can benefit from it
** remove news from my email address to reply by email **
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Page numbering with Merged Document and IF statements 1
Open print dialogue box when click on print icon in tool bar 5
Userform to Select what worksheets to print 1
Print specific range but user to select printer 4
Macro to print specified range of several work sheets 2
Printing Via By Macro for Network Printer 2
Mac Excel 2001 and PageSetup.PaperSize = xlPaperLetter 1
Excel won't print 2

Top