Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
speed up macros
Is there any way to speed up procedures that change Print Setup attributes?
The entire procedure is: Sub DavesPageSetup() With ActiveSheet.PageSetup .LeftHeader = "&8&F" '...15 total attributes End With End Sub That's it, and yet it still takes 30+ seconds. My other macros are fast but whenever I do something that involves the printer it's about as fast as a crippled turtle. Anyone know how to make it run faster? (I have an HP 842C Deskjet if that helps.) Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can you speed UP drag speed? | Excel Discussion (Misc queries) | |||
need for speed! | Excel Programming | |||
Macros i XL 2003 versus 2000 - speed problems | Excel Programming | |||
Why 2 macros differ so much in speed? | Excel Programming | |||
Speed? | Excel Programming |