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! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Closing VBA editior programmatically
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Closing VBA editior programmatically
I see. Pretty clever!
BrianB wrote in message ... SendKeys "%{F4}", True --- Message posted from http://www.ExcelForum.com/ |
Reply |
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 |