Print Button..

[kc2equ]

I am looking to have a button on the first page that will print all of the sheets in my excel file.. Can anyone help?

Thanks,
Justin

 

[Will_D]

Insert a control button and attach the following codes -
Sheets(Array("Sheet1", "Sheet2", "Sheet3")).Select
Sheets("Sheet1").PrintOut
Insert your sheets name for Sheet1 etc.

HTH

 

[Tom Urtis]

Instead of an array with hard coding the sheet names, this code line should do it:

ActiveWorkbook.PrintOut

 

[kc2equ]

I'm sorry to keep bugging everyone, but I am having some problems doing this... How do I add this button?

Thanks,
Justin

 

[kc2equ]

got it!