|
how to print multiple work sheets using vba
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 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. |
how to print multiple work sheets using vba
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 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. |
| All times are GMT +1. The time now is 02:16 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com