Can't access VBA-Editor.

[Christoph Dümmen]

I can not open the VBA-Editor window. Not with Alt+F11 nor the menu. The fan
starts to run, nothing happened. The window freezes and I have to kill the
application.
IT's with all Office 2003 SP1 products and VB6 on WinXP SP2.
The system worked properly for month before the problem showed up.
I reinstalled all Office products and VB6 but nothing helped.

Where is the problem. I tried sfc /scannow but that also didn't help.
Thanks
Chris

Crosspposting with excel.programming and office.developer.vba because the
problem is on all products.

 

[Helmut Weber]

Hi Christoph,

have you tried to remove all dots from the startup-folders?

--
Greetings from Bavaria, Germany

Helmut Weber, MVP WordVBA

Win XP, Office 2003
"red.sys" & Chr$(64) & "t-online.de"

 

[Christoph Dümmen]

No. I'll do now, but do you think thats a good idea if the problem is also
present with PowerPoint!! Also PowerPoint refuses to open the VBE-IDE with
Alt+F11.

Christoph

 

[Christoph Dümmen]

OK, I reinstalled Office before, the autostarts are all empty.
Chrisotph

 

[Tony Jollans]

This sounds like corruption. If reinstalling Office doesn't help, try
deleting the VBA key in the registry (which is left unchanged by
(re)installation) ...

HKEY_CURRENT_USER\Software\Microsoft\VBA

If you delete this key, a clean copy should be created from built-in
defaults when you open the VBE.

You may need to do this for more than one user if you have a multi-user
machine.

If you are uncomfortable with the registry a way of checking things out
would be to create a new (Windows) user (if you have authority) and to try
to open the VBE under that user. This won't obviate the need for the
registry change but will tell you if it's likely to work.

 

[Christoph Dümmen]

thanks, Tony.
But would that key also explain the same strange behaviour for the VB6 IDE?
Chris

 

[Christoph Dümmen]

Tony,
can't tell you how happy you made me today!

Comparing before and after .reg-export showed the following in key



[HKEY_CURRENT_USER\Software\Microsoft\VBA\6.0\Common]
"PropertiesWindow"="4 24 180 780 1"
"MainWindow"="290 105 1251 934 1"
"MdiMaximized"="1"
"Dock"=hex:02,00,b4,01,06,00,09,00,26,01,87,00,01,06,0b,04,ff,02,01,01,26,01,\
87,00,31,02,0b,04,ff,02,00,01,26,01,87,00,31,02,0b,04,05,00,00,01,0d,0e,b9,\
....10 more lines...
"FolderView"="1"
"Tool"=hex:00,00,00,00,09,00,00,00,41,6c,6c,67,65,6d,65,69,6e,00,ff,ff,ff,ff,\
ff,ff,ff,ff
"CtlsShowSelected"="0"
"DsnShowSelected"="0"
"UI"=hex:68,00,00,00,01,01,00,00,00,00,00,00,28,00,01,00,00,00,02,01,0b,00,00,\
80,00,00,08,01,00,01,00,00,16,00,0a,4d,00,65,00,6e,00,fc,00,6c,00,65,00,69,\
....500!!! more lines!!!

I think that is what youcalled corruption. thanks for the tip!

Chris