General Macro Question
General Macro Question
(OP)
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.






RE: General Macro Question
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.