| Home |
| Search |
| Today's Posts |
|
|
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Page setup too slow
Thank you! -- Mathieu "Don Guillett" wrote: ONLY change what is necessary and do it ONLY once (if you can) -- Don Guillett Microsoft MVP Excel SalesAid Software "Mathieu" wrote in message ... Hi, I have made a program which help me a lot and is fast. However, the portion of code below is so slow, comparing to the rest. Does anybody know how to make it faster? Thanks! Mathieu With ActiveSheet.PageSetup .CenterHeader = "&""Calibri,Gras""&20Suivi des factures bloquées" .RightHeader = "&D" .LeftMargin = Application.InchesToPoints(0.2) .RightMargin = Application.InchesToPoints(0.2) .TopMargin = Application.InchesToPoints(0.51) .BottomMargin = Application.InchesToPoints(0.33) .HeaderMargin = Application.InchesToPoints(0.25) .FooterMargin = Application.InchesToPoints(0.16) .PrintQuality = 600 .PrintTitleRows = "$1:$1" .PrintTitleColumns = "" .Orientation = xlLandscape .PaperSize = xlPaperLegal .FirstPageNumber = xlAutomatic .Order = xlDownThenOver .BlackAndWhite = False .Zoom = 85 .PrintErrors = xlPrintErrorsDisplayed End With -- |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| EXcel 2003 Page setup slow | Excel Discussion (Misc queries) | |||
| Page Setup Macro runs slow | Excel Discussion (Misc queries) | |||
| Page Setup SLOW trying excel 4..... | New Users to Excel | |||
| Macro for page setup of worksheets is slow | Excel Programming | |||
| VBA Page Setup/Formatting EXTREMELY Slow... Help! | Excel Programming | |||
Hybrid Mode
