Excel Spreadsheet print issue

Copper Contributor

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

 

1 Reply

@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)