View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
mary mary is offline
external usenet poster
 
Posts: 1
Default macro to close excel application other than application.quit

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.