View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Thomlinson[_3_] Jim Thomlinson[_3_] is offline
external usenet poster
 
Posts: 983
Default Running a macro Upon Closing

Auto Close is a little older that workbook close but they both function
exactly the same. The advantage to auto close is that you can place it in a
modue and export it for later use. But either way is just fine...

HTH

"Confused Excel Fan" wrote:

I have figured out the code to run Excel in Full Screen mode and get it to
have a "non excel" look to it. I want to run the reverse code however upon
closing excel. What code should I use to get a macro to run as I close the
program down.
Private Sub Workbook_Close() ???
Private Sub Auto_Close() ???

Or somethine entirely different. Thanks!
Chris