Hi,

Have an Excel spreadsheet that contains a macro that creates an new
worksheet and then fixes the pagesetup.

All the activesheet.pagesetup commands are painfully slow, but occasionally
they complete in the blink of an eye.

Can anyone help me to speed them up, or explain the inconsistent
performance?

Thanks,
Joe

Hi Spenceley

You can save the Excel file as a webpage
It will create a htm file and a folder with all pictures for you


--
Regards Ron de Bruin
http://www.rondebruin.nl



"Spenceley" wrote in message ...
Hi,

Have an Excel spreadsheet that contains a macro that creates an new worksheet and then fixes the pagesetup.

All the activesheet.pagesetup commands are painfully slow, but occasionally they complete in the blink of an eye.

Can anyone help me to speed them up, or explain the inconsistent performance?

Thanks,
Joe

Sorry, wrong thread

--
Regards Ron de Bruin
http://www.rondebruin.nl



"Ron de Bruin" wrote in message ...
Hi Spenceley

You can save the Excel file as a webpage
It will create a htm file and a folder with all pictures for you


--
Regards Ron de Bruin
http://www.rondebruin.nl



"Spenceley" wrote in message ...
Hi,

Have an Excel spreadsheet that contains a macro that creates an new worksheet and then fixes the pagesetup.

All the activesheet.pagesetup commands are painfully slow, but occasionally they complete in the blink of an eye.

Can anyone help me to speed them up, or explain the inconsistent performance?

Thanks,
Joe