Why does the VBA editor keep opening in Excel 2010?

Every time I run a certain macro (which is assigned to a button in my sheet), the VBA editor opens up and highlights the line below in yellow. It's not an error or even on of those red breakpoints, it's just simply a stoppage of the macro, which resumes when I press the green play button again. Why does this keep popping up?

    Cells.Find(What:="Reporting Period", After:=ActiveCell, LookIn:=xlValues, LookAt:=xlWhole).Select
shampouyaAsked:
Who is Participating?
 
SimonCommented:
I don't know whether that is related. My best guess is that VBE is storing 'invisible' information (relating to breakpoints and watches) that aren't always cleared down after use. Removing the module content, compiling and then pasting the content back in from the clipboard (or you can export,delete,import modules) seems to clear the problem wherever I've experienced it.
0
 
SimonCommented:
Try cutting the entire code from that module to the clipboard, then compiling the VBA project, then paste the code back in and compile again. That usually works for me.
0
 
shampouyaAuthor Commented:
I read something about maximizing and minimizing the VBA editor, is that related to this problem too?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.