Use VBA to set worksheet formatting

[Rick_Stanich]

I started this macro from macro recorder but it takes a very long time.
Is there something to do to speed it up?

Please Login or Register  to view this content.

Any hints, tips or examples are appreciated.

[watersev]

try this way:

Please Login or Register  to view this content.

Some parameters are as you would like to have as default value so no need to change - the way to speed it up

[TMS]

Configuring the Printer settings was always very slow, in my experience ... and you're going through the process three times. It also used to depend on the printer driver, though it's a while since I've tried this so it might have improved

If all the pages are (roughly) the same, try grouping the sheets and recording the macro as you set the parameters once for all the pages. Having recorded the macro, edit it to remove any default settings

Regards

[romperstomper]

PageSetup (before XL2010) is notoriously slow due to the communication between VBA and the printer drivers. You should either try to format the sheets ahead of time (e.g. use a template sheet) or use the old XLM PAGE.SETUP method:

Please Login or Register  to view this content.

Note that you need to activate each sheet when using this.

[Rick_Stanich]

Thanks for the help and tips!

[solnajeff]

Hi

This has been a pain for some time, however you can speed it up using the Excel 4 macro function.

Here are a couple of links explaining how to go about it.

http://www.mcgimpsey.com/excel/udfs/pagesetup.html
http://www.pcreview.co.uk/forums/thread-947330.php

Regards

Jeff