Macros Execute Very Slow Problem

[Rene''48]

Hello Tech Support,

I am writing a macro in excel 2003:
I have written a macro that uses 7 other macros. My problem is if I execute
the macro again the macro executes very slowly. I find I have to close excel
and open the excel file again so that it will not execute slowly. Is this
taking up a lot of memory? Are there any macro codes that will solve this
problem without having to close the excel file?

Thank you for your help.

Rene'

 

[Mike H]

Hello Tech Support,

Hi,

This isn't tech support, it's a community in which people give their time
freely to help others.

Without seeing your macros it's hard to be specific but a good start is


sub macro1()
Application.ScreenUpdating = False
Application.Calculation = xlCalculationManual

'call your macros

Application.ScreenUpdating = True
Application.Calculation = xlCalculationAutomatic
end sub

Mike