Reproducible crash in VBA editor

[Michael W. Daniels]

I'm running Windows XP SP2 and office 2003; I can crash the VBA editor
as follows:

Steps:

1) Open Microsoft Access
2) Select "View | Code"
3) Select "Tools | Options..."
4) Select "Editor Format" tab.

or

1) Open Microsoft Word
2) Select "Tools | Macro | Visual Basic Editor..."
3-4) as above

or

1) Open Microsoft Excel
2-4) as above

Result:

Access/Word/Excel crashes.

Is this a known problem?

 

[Tony Jollans]

No problem known to me - and it doesn't do that for me. I would suggext you
have some corruption somewhere - probably in the Registry.

VBE Options are stored in:

HKCU\Software\Microsoft\VBA\6.0\Common

You could try ...

Close the VBE in *all* applications
Rename the above key
Open the VBE in one application - a new key should be created
Try your stuff again
Close the VBE to save youir changes.

 

[Michael W. Daniels]

VBE Options are stored in:

HKCU\Software\Microsoft\VBA\6.0\Common

You could try ...

Close the VBE in *all* applications
Rename the above key
Open the VBE in one application - a new key should be created
Try your stuff again
Close the VBE to save youir changes.

Yep, this worked for me. Thanks!

 

[Colt Kwong]

Hi,

I faced the same problem, but the suggestion of modifying RegEdit does not
work for me. FYI: I installed Excel 12 in the past and I noticed the
corruption happen after installation of this beta software. Is it related or
is there any way for me to install the "original" VBE?

Regards,
Colt

 

[Tony Jollans]

Not having Office 12 I have no idea what it might do - it may trigger
dormant features in Office 11 for all I know. That said, if the whole VBA
key is deleted I would expect it to be rebuilt from built-in defaults next
time the VBE was invoked and I would expect that to clear most, if not all,
issues.