ExcelBanter - Close VB in Code

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Close VB in Code (https://www.excelbanter.com/excel-programming/285712-close-vbulletin-code.html)

Paul Watkins[_2_]

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

Ron de Bruin

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

Paul Watkins[_2_]

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

All times are GMT +1. The time now is 11:55 AM.