VBA PageFormat Command is very slow. Any ideas ?

[Harj]

Hi,<br>
<br>
We have developed an application running in Excel VBA and are having performance problems under some PCs.<br>
<br>
Most PCs are working fine and the time it takes to format a page and print is very quick (2 seconds). However, some PCs are taking about 2-3 minutes to do the same commands.<br>
<br>
The type of commands are:<br>
<br>
With ActiveSheet.PageSetup<br>
.LeftHeader = &quot;&quot;<br>
.CenterHeader = &quot;&quot;<br>
.RightHeader = Date<br>
.LeftFooter = &quot;&&quot;&quot;Arial,Regular&quot;&quot;&8Report produced for &quot; + cUser<br>
.CenterFooter = &quot;&&quot;&quot;Arial,Regular&quot;&quot;&8Page &P of &N&quot;<br>
.RightFooter = &quot;&&quot;&quot;Arial,Regular&quot;&quot;&8Produced by SMARTv&quot; & vRef<br>
<br>
They are just normal Excel VBA pageformat commands and take about 5-10 secs each on the problem PCs.<br>
<br>
Has anyone come across this situation before ? Any ideas will be appreciated.<br>
<br>
Thanks.

 

[DougP]

Well I guess all PC's are the same Operating system and CPU speed and RAM amount???