Macro to setup printing options for whole workbook

[jsantos]

Hi
Have the following code that i did in order to set all sheets on the workbook to have the same printing options, unfortunatly when i changed the code so it applies to all worksheets, VBA doesn't like my aproach. Could someone help, please?

Please Login or Register  to view this content.

Many thanks
Jsantos

[gyclone]

You are missing the end of the "For/Each" loop. Also, you probably shouldn't use "PageSetup" as the name of the Sub, since "PageSetup" already means something in VBA. Try this:

Please Login or Register  to view this content.

[jsantos]

Many thanks gyclone
That does the trick

Regards
Jsantos