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.

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
:) :) :) :) :

--
Message posted from http://www.ExcelForum.com