Forum Discussion

Simon_Pedley's avatar
Simon_Pedley
Copper Contributor
Sep 06, 2022

Excel Spreadsheet print issue

I have a spreadsheet with multipule pages however when I try and print it will only allow the first 12 pages to print.

 

excel

1 Reply

Sort By
  • NikolinoDE's avatar
    NikolinoDE
    Gold Contributor
    Sep 06, 2022

    Simon_Pedley 

    ...with a bit of VBA, it might work 🙂

    You can use the following macro to print out all worksheets in the active workbook.

    Only the visible tables are printed:

    How to print all Excel spreadsheets in a workbook

    Sub PrintVisibleTables()
Dim Workbook As Worksheet
For Each Workbook In Worksheets
If Workbook.Visible = True Then
Workbook.PrintOut
End If
Next workbook
end sub

    The macro prints the tables on your default printer.

    For testing, you can replace the PrintOut command with the PrintPreview command.

    Then only the page view is displayed without the tables being printed.

     

    Hope I could help you with these information.

     

    NikolinoDE

    I know I don't know anything (Socrates)

Resources