| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code to launch VB editor
Thank you Martin
"Martin" wrote: You could also use this: CommandBars("Worksheet Menu Bar").Controls("Tools").Controls("Macro").Controls ("Visual Basic Editor").accDoDefaultAction "Boog" wrote: That has to be the only combination I didn't try. Thank you for the prompt solution. Cheers. "Office_Novice" wrote: Sub vbe() Application.vbe.MainWindow.Visible = True End Sub 'Tools --Macro--Security 'Click the Trusted Publisher Tab 'Click Trust access to Visual Basic Project Checkbox 'Click ok "Boog" wrote: I am running XP with Office 2002. What is the VB code to launch the VB editor. I would like to assign it to a toolbar button. It would save time, albeit very little, but in the world of nanoseconds and milliseconds, it is long. I have searched newsgroups, Google and visited various websites. Chip Pearson's site is superlative at providing code to work in the editor but I did not locate the code to actually launch the editor. I have also used all combinations of code in VB (ie: Application.VBE. ...) but cannot produce the desired result. Thank you ahead of time for your time and consideration. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Closing the VBA Editor using code | Excel Worksheet Functions | |||
| Macro launch - Button vs Manual launch , has different results. | Excel Programming | |||
| RegEx in VBE code editor | Excel Programming | |||
| Get VSTO code to run on every launch of Excel | Excel Programming | |||
| printing module code from vba editor | Excel Programming | |||
Threaded Mode
