Hi,
What might cause this behaviour where the VBA window keeps opening up over Excel when Excel opens up? According to the user, they do not have any macro's in the Personal Macro workbook (which was my initial assumption). I have encountered this in the past too, and am now interested to find out if anyone knows why and what causes this. TX.
Excel VBA editor keeps opening up
-
- gamma jay
- Posts: 25455
- Joined: 17 Mar 2010, 17:33
- Location: Cape Town
Excel VBA editor keeps opening up
Regards,
Rudi
If your absence does not affect them, your presence didn't matter.
Rudi
If your absence does not affect them, your presence didn't matter.
-
- Administrator
- Posts: 78524
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Excel VBA editor keeps opening up
Does the user simply get the Visual Basic Editor or does it open in debug mode?
Does the VBE get the focus or is it opened behind Excel?
Does the VBE get the focus or is it opened behind Excel?
Best wishes,
Hans
Hans
-
- Microsoft MVP
- Posts: 656
- Joined: 24 Jan 2010, 17:51
- Status: Microsoft MVP
- Location: Weert, The Netherlands
Re: Excel VBA editor keeps opening up
Any addins the user has installed perhaps?
-
- gamma jay
- Posts: 25455
- Joined: 17 Mar 2010, 17:33
- Location: Cape Town
Re: Excel VBA editor keeps opening up
Hi,
Chatting to the user, they say it activates the moment excel gets focus. (Even when they unlock their workstation and excel is open, then it pops up the VB Editor. The editor open over excel, (not behind it) and it is not in debug mode. The module apparently is blank.
Jan; they are not aware of any new add-ins that have been activated, although this is a possibility as add-in updates are often done automatically. I can troubleshoot their PC by switching off all add-ins and systematically activating them to see who is the culprit.
TX Guys!
Chatting to the user, they say it activates the moment excel gets focus. (Even when they unlock their workstation and excel is open, then it pops up the VB Editor. The editor open over excel, (not behind it) and it is not in debug mode. The module apparently is blank.
Jan; they are not aware of any new add-ins that have been activated, although this is a possibility as add-in updates are often done automatically. I can troubleshoot their PC by switching off all add-ins and systematically activating them to see who is the culprit.
TX Guys!
Regards,
Rudi
If your absence does not affect them, your presence didn't matter.
Rudi
If your absence does not affect them, your presence didn't matter.
-
- 5StarLounger
- Posts: 817
- Joined: 24 Jan 2010, 15:56
Re: Excel VBA editor keeps opening up
That sounds like a long-standing bug. If they unmaximise the VBE and resize the window manually, it should go away. (assuming it's the same issue)Rudi wrote:Even when they unlock their workstation and excel is open, then it pops up the VB Editor.
Regards,
Rory
Rory
-
- gamma jay
- Posts: 25455
- Joined: 17 Mar 2010, 17:33
- Location: Cape Town
Re: Excel VBA editor keeps opening up
Weird one. I'll bear that in mind if the other advise does not resolve the issue.
TX Rory!
TX Rory!
Regards,
Rudi
If your absence does not affect them, your presence didn't matter.
Rudi
If your absence does not affect them, your presence didn't matter.