PDA

View Full Version : clear memory?



tkaplan
11-28-2005, 09:21 AM
I'm having a very strange issue:
I have a macro that based on certain criteria hides and unhides some sheets and saves the file as a different name.
i run this macro on the first file and it's size is 1.3 meg. i run the macro and the new file - the only difference it has is that two sheets are not hidden any more and the size is 1.9 meg. i hide those sheets again and the size goes down to 1.3 meg. i unhide them and the file size stays 1.3.

Does anyone have any idea why the file size is going up when the two sheets are unhidden by the macro, but when i do it manually the file size does not change?

Thanks in advance
tkaplan

tkaplan
11-28-2005, 01:53 PM
small update:
I dont need to hide and unhide sheets. if i unprotect the workbook and save it, the size comes down and stays down even if i protect it again.
if i just unprotect and protect without saving in between, the size stays high.

any suggestions???