View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
JW[_2_] JW[_2_] is offline
external usenet poster
 
Posts: 638
Default Excel Print All Tabs Macro

Su
Sub code()
Dim sht As Worksheet
For Each sht In ActiveWorkbook.Worksheets
sht.PrintOut
Next sht
End Sub

HTH

prahz wrote:
Can anyone help me with this newbie question:

I need a macro that prints all tabs in a given workbook. Can anyone
provide me the code please?

Thanks,

Paul