Excel Spreadsheet print issue

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)