How to check if the program is in debug mode using VBA
Here is a simple way to check if the program is in debug mode using VBA
Sub Check_VBE()
Dim oVBe As VBProject
Set oVBe = ThisWorkbook.VBProject
If oVBe.Mode = vbext_vm_Run Then
MsgBox "Executing.."
MsgBox oVBe.VBE.MainWindow.Visible
End If
End Sub
The code uses VBProject. Ensure that the Microsoft Visual Basic for Applications Extensibility reference is loaded
Microsoft Visual Basic for Applications Extensibility reference
No comments:
Post a Comment