| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA to monitor/alert when/if a ActiveCodePane.Window = "General" has focus
2003, 2007
The following will work when executed. If Application.VBE.VBProjects.VBE.ActiveCodePane.Wind ow.Caption = "General" Then MsgBox Application.VBE.VBProjects.VBE.ActiveCodePane.Wind ow.Caption & " is Open" End if How can the same logic be coded into a "Monitor" event? Similar to "On error goto" where if a error occurs while executing a sub proceedure. In short, when a user opens a specific VBProject code window (Caption: = "General") Then a MsgBox displays a message like above. TIA EagleOne |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Handle an "Excel cannot complete..." alert window withVBA | Excel Programming | |||
| how do i reset the default from "general" to "number" | Excel Discussion (Misc queries) | |||
| "general" cells turned into "accounting" - why and how to reverse | Excel Worksheet Functions | |||
| Excel 2003 VBA - "Maximizing" Window & "Calculating" Workbook | Excel Programming | |||
| Changing format of column from "general" to "currency" | Excel Programming | |||
Threaded Mode
