OK thanks. I will try.

I use only one workbook that uses one sheet to display different reports.
The reports are built using Copy/Paste from another sheet.



"Tom Ogilvy" wrote:

Clean out your temp directory

Also, if it is your code that is getting slower, then make sure you set

ActiveSheet.DisplayPageBreaks = False

anytime they might get displayed.

You might check out Charles Williams' site
http://www.decisionmodels.com

he has some pages on Excel and performance.

--
Regards,
Tom Ogilvy

"Romuald" wrote in message
...
I use a workbook on Excel 2002 and windows XP. It is used to display
reports
built with VB code.

When the users display many reports, the Excel becomes slower and slower.
I
check my code and all objects are cleaned after their use. DO you have
already met problems of memory leak? Is it possible to clean memory using
VB?

thanks for your help!