Added one macro, now all Excel is very slow?

[acctemp]

I added a two line macro to clear a range after a button was clicked.
Now this spreadsheet takes 8 minutes to open/close and some unrelated
spreadsheets take 2-3 minutes. Before this change it took at most 5
seconds to open/close all spreadsheets. Saving the file is still very
quick, but printing takes 2-3 minutes. These are fairly small
spreadsheets between 600K-2mb in size with relatively little data.

I tried clearing temp files, rebooting, removing the macro I had just
added, enabling manual calculation, nothing makes a difference. I am
using Excel 2000.

 

[acctemp]

Hi,

Never mind, lol. By deleting the emf files in a temp directory the
problem was fixed. The strange part is that this directory was
invisible to Windows but I could see it in DOS.

 

[Bob Phillips]

In windows explorer, select the View tab, and there is an item titled
'Hidden files and folders, make sure this is expanded, and check the 'Show
hidden files and folders' button.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)