I am having problems with the VBA Editor freezing at the most inconvenient of times when writing code and then clicking to
the Sheet I'm working on, it just freezes up the whole of Excel and it has to be shut down and opened up again.
It seems like a memory problem at first, but there is sufficient memory
( 768Mgs, OS is XP Pro, Excel 2000, 9.02).
The work is not lost becuase I'm able to Save even at PC Re-boot,
I've tested on 2 different PC's and the same happens. The only way to avoid the freeze it seems, is
before I switch to view a worksheet, is to Save then click off VBA Editor and re-open.
When doing so, another symptom is it seems a huge amount of memory is freed up, ( pardon the terminology)
also a message that pops up when re-opening that same workbook that there are Formulas Linked to another workbook, but unable
to find any after tediously searching every worksheet by using "Find, Look in Formula" there is nothing found, yet.
This freezing may happen twice a minute whilst pointing the mouse cursor from any VBA Edit window or worksheet and it's
getting to a point of repetitiously having to Save, click off VBA Editor, and Click back on again each time I need to look at
a respective Worksheet.
This only happens when I am doing fixes in VBA Editor, but whilst the workbook is running with no VBA editor opened, the very
very long macro works fine.
I hope the above symptoms will help solve this time consuming issue.
Any suggestions would be appreciated,