Is there a specific way to 'end' a macro. To be more specific, when I open up the VB editor, all of the macros that I have run during this session should up in the 'Project Explorer'. I am assuming this means that they are not completely closing out after being run and if I run too many I get an error saying that the macro is unstable. Thanks in advance.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations cowski on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!
General Macro Question
- Thread starter Creigbm
- Start date
I have had this happen, as well. I don't know what triggers it.
To close the projects, I tile all windows and just start clicking, close the VB editor and reopen the macro for editing.
I have started getting in the habit of ending my macros with an End statement and unloading forms to polish everything off. Also, set up something for a form's Terminate event in case a form is closed by the "X" box instead of by whatever means the form controls allow.
![[bat]](/data/assets/smilies/bat.gif "[bat] [bat]")
All this machinery making modern music can still be open-hearted.
To close the projects, I tile all windows and just start clicking, close the VB editor and reopen the macro for editing.
I have started getting in the habit of ending my macros with an End statement and unloading forms to polish everything off. Also, set up something for a form's Terminate event in case a form is closed by the "X" box instead of by whatever means the form controls allow.
All this machinery making modern music can still be open-hearted.- Status
Similar threads
- Locked
- Solved
- Locked
- Question