(worksheet).delete method causes Project Reset !!

[stevebovy]

Hi,

I have encountered what seems like a very frustrating and stupid Excel vba bug.

When I use the worksheet.delete method. My vba project is RESET.

All forms object classes and variables disapear into the BIT BUCKET.

Does any one have any ideas on what is causing, this, and wehter there
is a way to avoid it or work around it. ??

 

[stevebovy]

Thanks to everyone who has responded.

The Forms objects are great for visually impaired simplistic functionality ):

I was using the activeX button because it has much richer capabilities

I tried using the OnTime technique with the Sereialize ( ) function to give it 1 or 2 second breathing space. But I found that approach to be un-reliable. It tends to cause excel to crash, i thnk becasue when
the timer kicks in and you try to create new classes or re-init new vars,
the vb address space may still be in the middle of destroying or reseting the vb project address space, and may be in an undefined and/or unstable
state.

 

[ZVI]

Yes, it could be known memory leakage problem with ActiveX objects in Excel worksheets.
Regardless it has been recognized for XL97, Out of Virtual Memory error sometimes has been caught by me in case of using embedded Visual Basic toolbar controls in sheet.
There are some links on this theme:
http://support.microsoft.com/kb/238570
http://support.microsoft.com/kb/319998
http://www.decisionmodels.com/memlimitsd.htm