Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Closing VBA editior programmatically
I have a macro which ends like this:
With ActiveWorkbook.VBProject.VBComponents("ThisWorkboo k").CodeModule StartLine = .CreateEventProc("BeforeClose", "Workbook") + 1 .InsertLines StartLine, _ "Msgbox ""Blahblahblahblah...."",vbOkOnly" End With When I run the macro, it does whatever it has to do and then ends by displaying the code module window with the above code. This will puzzle my friends who will run the macro since they don't know a thing about VBA. How can I close the VBA editor programmatically? Thanks in advance! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Closing workbooks w/o closing Excel | Excel Discussion (Misc queries) | |||
Visual basic editior | Excel Worksheet Functions | |||
Can I add equation editior to my toolbar in EXCel as an icon? | Excel Worksheet Functions | |||
closing excel after closing a workbook | Excel Programming | |||
Programmatically Add Reference` | Excel Programming |