Exit XLS Padlock after VBA executes

reektoubbs

New member
My VBA code opens another workbook and executes commands and then closes the workbook and closes my VBA workbook. This works before converting the VBA into an exe. After that the newly created exe named “My Application” remains open even after the VBA is completed. I have to manually close the “My Application” workbook. How do I accomplish this within the settings of the exe or in the VBA.
 
Thanks that worked to close the application when task are completed. But the original xlsm opens on execution, although it closes on comoletion. How do i stop the xlsm from showing at all. I only want the userform to be shown.
 
Back
Top