<div>
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.
</div>


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.

<div>
I read something about maximizing and minimizing the VBA editor, is that related to this problem too?
</div>


I read something about maximizing and minimizing the VBA editor, is that related to this problem too?

<div>
<div class="content wysiwyg-content">
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?<br />
<br />
&nbsp; &nbsp; Cells.Find(What:=&quot;Reportin<wbr />g Period&quot;, After:=ActiveCell, LookIn:=xlValues, LookAt:=xlWhole).Select
</div>
</div>


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

Why does the VBA editor keep opening in Excel 2010?

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Visual Basic for Applications (VBA) enables building user-defined functions (UDFs), automating processes and accessing Windows API and other low-level functionality through dynamic-link libraries (DLLs). VBA is closely related to Visual Basic and uses the Visual Basic Runtime Library, but it can normally only run code within a host application rather than as a standalone program. It can, however, be used to control one application from another via OLE Automation. VBA is built into most Microsoft Office applications.