View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
David P.[_2_] David P.[_2_] is offline
external usenet poster
 
Posts: 1
Default Run "Workbook Open" once

I have a template that when it opens it automatically runs a macro that
allows me to type in a text box what I want to save the file as and then
saves it in the directory where I want it saved. The problem is that once it
is saved I don't want it to run the macro again when I reopen that saved
file. Should I put in the code at the end some way to deactivate the macro so
that it no longer automatically runs when opening that newly saved file?
Thank you.

David P.