I believe you have an answer in your other thread.

Ken Puls, CMA - Microsoft MVP (Excel)
www.excelguru.ca

prakash wrote:
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.