i need to print 2 diff worksheets in the same file. Is there a way i could set so that when i click print from worksheet 1, it will also print a copy in worksheet 3. worksheet 2 will no be printed. thanks

Manually, you could hold the Ctrl key and click the sheet tabs for Sheets 1 and 3 and then click Print. It will print out whatever sheets you have "grouped" in this manner. To make it automatic, assign this macro to a custom button. It will... 1 - Store the name of the ActiveSheet 2 - Select Sheets 1 and 3 3 - Print them out 4 - Reselect the ActiveSheet Sub PrintMySheets() CurSht = ActiveSheet.Name Sheets(Array(1, 3)).Select ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True Sheets(CurSht).Select End Sub

P.S. It would be helpful if you could be more specific with your subject lines. If everyone who had an Excel question used a subject line as generic as Excel Question, searching the archives by subject line and browsing the subject lines for threads of interest would be pretty much useless. You currently have 2 threads running in this forum with a subject line of "excel question" - threads that are not related to the same subject manner. May I suggest something like these subject lines in the future: Hiding "0" Results in Excel and Printing Multiple Sheets in Excel

thanks...and will do!