Dave, I don't understand your "can't delete" statement about the code module.
What prevents the deletion? On the out of memory issue, have you looked for
recursive calls in your code, where it keeps calling itself, infinite calc
routines due to auto calc procedures, etc. If you have your code in sub
routines, you could run them one at a time to find the cuplrit, else, just
delete all the code in the procedure that produces the error message. You
don't have to delete the module, just the code.

"Dave Unger" wrote:

Hello,

I know this topic has been addressed many times in this group, but I
can't seem to find an answer to my particular case. Running Excel97.

I have a fairly small workbook, approx. 200Kb, containing 9 worksheets
with a few formulas on each sheet - nothing very complicated. It is a
Source to another workbook. The main macro opens the Target workbook,
adds a few links to the Source, then closes the Target. Up until a
short time ago, everything was working fine - suddenly I'm getting the
dreaded "Out of memory" message when trying to edit any macro in the
module. I can export the module, but I can't delete it. Also, the
Target file is remaining visible in the Project Explorer, even though
it's closed. Rob Bovey's VBA Code cleaner doesn't appear to function
normally in this situation, it just creates a duplicate module in the
same project (which I can delete).

I'm running out of ideas, any help would be greatly appreciated -
thank you.

Regards,

Dave