View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
gloria gloria is offline
external usenet poster
 
Posts: 1
Default unable to close macro using auto_close or application.quit

I have a macro that is processed using sub auto via a
hyperlink. Basically, if someone cick the hyperlink it
will run the macro. All the processing is invisible. Now,
when this marco is run by just clicking the excel
application it will run invisible and end he application
invisible. However, when this marco is processed using
the hyperlink, it will process invisible, but at the end
it will show the sheet that i use to create the marco. I
have used application.quit or auto_close, however, they
rerun the process again and again. I am not able to use
any of the close statment to shut of the application one
the macro ends. Basically, i do not want the user to see
the excel application. thanks in advance