error no memory with one workbook

R

raw

Hi I have a workbook 1 that i have been working on for many years adding
new sheet macros etc

But lately if i open workbook 1 on its own it is fine but if i try and
open another workbook (with or without macros enabled) i get a message
box say "Not enough memory" and will not let me open the second
workbook, I have tried deleting all the modules and all forms thinking
they might be the trouble, but still no joy

If i close workbook 1 and open the other workbooks, they open fine and
work fine macros etc so this leads me to think that it is workbook 1
that is creating the problem, has any one heard or had this before can
i scan the workbook file etc

Need help please

Have the same problem on other PCs

Running excel 2000

Does some time bring up the need to close/send report box if I click to
many times

Many thanks
 
Top