how to print multiple work sheets using vba

P

prakash

Hi all ,
iam a new vba developer i have a question can any body help me to
how to do this

i have a workbook which contains 40 sheets but i want to print only 15
out of 40 as a standard routine task on fixed range data (a1:t30) in
all 15 worksheets

so i need to create command button to select (a1:t30) ranges in those
15 sheets and also i have to invoke
Application.Dialogs(xlDialogPrint).Show to choose printer and then
print


problem is when i invoke the dialog box it is printing only the active
sheet that is one

how to write a code to achieve this
thanks in advance ,
prakash.
 

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

Excel vba help needed 1
A macro code to print multiple sheets in different w.books 3
Excluding worksheets from printing 2
Print Multiple Sheets to PDF Problem 3
Question with existing print macro 5
Printing Sheets in a Workbook 3
Change multiple worksheets at one time to print in color 1
Excel 2003 - How to print areas in separate sheets to 1 pdf file 1

Top