MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Why macro is slow? (auto_open does some page setup)

Posted by Pasi J Vartiainen on May 15, 2001 6:05 AM

I have excel worbook, which has 12 sheet. All sheets need some setting up for printing, I am doing that with Auto_Open macro. Macro sets up printarea, and pagesetup (eg footers, orieantation etc) ... I wonder what makes macro REALY slow, it runs about 45 minutes. Macro is done by recording, and Application.Screenupdating=False added in order to get some speed. What might couse this slowness, it is not memory, there is some 100 megs available memory when macro is running.

Hope that some-one can help.

Pasi J. Vartiainen

Posted by Kristen on May 29, 2001 9:15 PM

Post your code on the message board and then we can look at it