macro to close excel application other than application.quit

M

mary

I have a macro that i used the sub auto to run the macro from a
hyperlink. It runs well. The application is not visible at the start
of the process, however, visible at the end. All i need is for the
macro to run as invisible when the process is started using an
hyperlink. I add the application.quit at the end of the macro hoping
it will close excel application once the macro has ran. All it did was
rerun the process again and again. I strongly beleive this is because
I am running the macro through an hyperlink. It works well running it
by click just the excel sheet. thanks in advance.
 
C

Celtic_Avenger

Have you tried to split the process.

ActiveWorkbook.Close (this may ask for a save)
or
ActiveWorkbook.Close False (this wont as for a save)

then add

Application.quit


This may help, or others may be able to give a better idea!

Celtic_Avenger
:) :) :) :) :
 
Top