Is it possible to close the VBE by using code??
i have a macro that runs and inserts code into a new workbook that is opened up, but when the code is inserted into the new workbook, the VBE opens and shows the code. i dont want this to happen. is there anyway to either stop the editor opening or to close it once it is open.
the application.Quit command closes Excel and i have tried many different things like
Windows("Microsoft Visual Basic"
.Quit
Application("Microsoft Visual Basic"
.Quit
Application("Microsoft Visual Basic"
.Close
Application.Windows("Microsoft Visual Basic"
.Close
Application.VBE.Close/Quit/Exit
im sure there is a command out there somewhere that will work, i just cant seem to find it.
Any ideas??
i have a macro that runs and inserts code into a new workbook that is opened up, but when the code is inserted into the new workbook, the VBE opens and shows the code. i dont want this to happen. is there anyway to either stop the editor opening or to close it once it is open.
the application.Quit command closes Excel and i have tried many different things like
Windows("Microsoft Visual Basic"
Application("Microsoft Visual Basic"
Application("Microsoft Visual Basic"
Application.Windows("Microsoft Visual Basic"
Application.VBE.Close/Quit/Exit
im sure there is a command out there somewhere that will work, i just cant seem to find it.
Any ideas??