View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Bob I Bob I is offline
external usenet poster
 
Posts: 2,819
Default Run macro on exit

Suggest you do it Automatically on open instead. Just rename the macro
you use to Auto_Open .

Steve wrote:

I have a multi-sheet document. Before I exit I like to click box A1 in all
sheets so that when I open the document everything is all neat and tidy and I
know that I am at the very start of the sheet.

Is there a way to do this automatically?
Perhaps a macro that runs "on exit" ?