Solved: Persistent VBE Window

[geekgirlau]

I have a small but irritating problem ...

I have a timesheet workbook that I use to record dates, times and projects. This is open all day, and I note the time as I start working on a new task or project.

A couple of sheets in the workbook have a Worksheet_Change macro (I can't be bothered typing times properly, so whipped up a macro quickly when I was bored!).

The problem is that periodically the VBE window opens by itself. The workbook is open all day, but I have no need to go into the VBE window. However several times a day I look on my Task Bar and there it is! I shut it down, but as soon as my back is turned (figuratively of course, I haven't worked out how to type that way yet) it pops up again.

Maybe I should be asking Babydum about poltergeist activity in Excel, but in the meantime does anyone else have a solution?

[Desert Piranha]

Hi geekgirlau,

As you are doing other work, are you inaverdently hitting some kind of keyboard shortcut, causing the VBE to open?

Dave

I have a small but irritating problem ...

I have a timesheet workbook that I use to record dates, times and projects. This is open all day, and I note the time as I start working on a new task or project.

A couple of sheets in the workbook have a Worksheet_Change macro (I can't be bothered typing times properly, so whipped up a macro quickly when I was bored!).

The problem is that periodically the VBE window opens by itself. The workbook is open all day, but I have no need to go into the VBE window. However several times a day I look on my Task Bar and there it is! I shut it down, but as soon as my back is turned (figuratively of course, I haven't worked out how to type that way yet) it pops up again.

Maybe I should be asking Babydum about poltergeist activity in Excel, but in the meantime does anyone else have a solution?

[geekgirlau]

Well my initial response to this is an indignant "Of course not!".

But actually ... hmmm, don't know. I'm switching between multiple applications constantly. It appears to happen while Excel does not have the focus. Also I find it hard to believe that I could hit [Alt-F11] without realising it - is there another shortcut for the VBE?

[c19h28O2]

There isn't something in the code that is making it pop? does it always open on the same module/procdure?

[johnske]

Have you got an Application.Goto "Something" somewhere where "Something" is also the name of a procedure? (that'll do it)

[geekgirlau]

No Application.GoTo ...

I've now completely cleared Personal.xls (there was only rubbish in there anyway), leaving only the sheet macro below - will let you know if this has resolved anything ...

[VBA]
Sub NewWeek()
If vbYes = MsgBox("Start new week?", vbYesNo + vbQuestion, "New Week?") Then
On Error Resume Next
Range("dtmWE") = Range("dtmWE").Value + 7

Range("Timesheet").ClearContents
Range("Reimburse").ClearContents
Range("Comment1").Formula = ""
Range("Comment2").Formula = ""
End If
End Sub

[/VBA]

[geekgirlau]

Still occurring ...

[Desert Piranha]

Still occurring ...

Hi geekgirlau,
Do you have an "Add In" that would be causing it?

I just saw an Add In somewere else that opens the VBE window.

[geekgirlau]

I just removed the Analysis Toolpak add-in - will let you know if this resolves the issue.

[Shazam]

You could try this.


In Excel 2002 and 2003 it has a Detect and Repair feature. Go to the menue bar that says Help Then click on Detect and Repair and go from there. See if that helps.

[geekgirlau]

The problem has not occurred since removing the Analysis Toolpak - will monitor for a couple of days to see what happens.

[Desert Piranha]

The problem has not occurred since removing the Analysis Toolpak - will monitor for a couple of days to see what happens.

Kool, (got my fingers crossed)

[geekgirlau]

Yep, that seems to have fixed it, although of course if you need the Toolpak it's a bit of an issue ...

[johnske]

So THAT's where the poltergeist lives!! Good to see you got it sorted

[Desert Piranha]

Yep, that seems to have fixed it, although of course if you need the Toolpak it's a bit of an issue ...

Kool, So there has to be some code or key combination, that when used in conjunction with the Toolpak opens the VBE. Interesting.

Now that you know its the Toolpak, when you have it loaded, you can watch for the VBE to open, and kinda watch to see what is going on when it happened.

[geekgirlau]

The interesting thing here is that it occurs when Excel does not have the focus - hard to believe that a key combination from outside the application could be launching the VBE window!

[Shazam]

The interesting thing here is that it occurs when Excel does not have the focus - hard to believe that a key combination from outside the application could be launching the VBE window!

Hi geekgirlau,


Have tried to Detect and Repair on your excel? It will put your excel on the default settings.

[Desert Piranha]

The interesting thing here is that it occurs when Excel does not have the focus - hard to believe that a key combination from outside the application could be launching the VBE window!

Hi geekgirlau,
What you are saying sounds logical to me.