printing

[Guest]

We have spreadsheet reports that need to be printable on a global level. I
understand that each country may have their own settings when it come to
printing.

Therefore, how do I make our reports on excel printable on a global level
without the users fiddling too much with the settings?

 

[Jim Rech]

I don't think you have any choice but to run a macro that adjusts each
sheet's page setup to the local settings as needed.

Personally the only issue I've run into is paper size. For that I run this
sub and then change all the page setups:

''Returns default paper size
'' 1 = 8.5x11
'' 9 = A4
'' etc
Function GetPaperSize() As Integer
GetPaperSize = 1 'Default
Workbooks.Add xlWorksheet
On Error Resume Next ''No printer driver installed
GetPaperSize = ActiveSheet.PageSetup.PaperSize
ActiveWorkbook.Close
End Function

--
Jim
| We have spreadsheet reports that need to be printable on a global level.
I
| understand that each country may have their own settings when it come to
| printing.
|
| Therefore, how do I make our reports on excel printable on a global level
| without the users fiddling too much with the settings?