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?