| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Close VB in Code
Hi
Is it possible to add a line of Vb code to a macro that will close the visual basic editor window automatically? If so, how is it written Thanks Paul |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Close VB in Code
Try this Paul
Application.VBE.MainWindow.Visible = False -- Regards Ron de Bruin (Win XP Pro SP-1 XL2000-2003) www.rondebruin.nl "Paul Watkins" wrote in message ... Hi Is it possible to add a line of Vb code to a macro that will close the visual basic editor window automatically? If so, how is it written Thanks Paul |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Close VB in Code
Thanks again Ron, it works great
Paul "Ron de Bruin" wrote in message ... Try this Paul Application.VBE.MainWindow.Visible = False -- Regards Ron de Bruin (Win XP Pro SP-1 XL2000-2003) www.rondebruin.nl "Paul Watkins" wrote in message ... Hi Is it possible to add a line of Vb code to a macro that will close the visual basic editor window automatically? If so, how is it written Thanks Paul |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Auto save as text and close in code? | New Users to Excel | |||
| How to code the Macro to save and close a file? | Excel Discussion (Misc queries) | |||
| close form code | Excel Discussion (Misc queries) | |||
| VBA code to automatically close file | Excel Programming | |||
| Close worksheet with Macro or Code | Excel Programming | |||
![Paul Watkins[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
