View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mike[_40_] Mike[_40_] is offline
external usenet poster
 
Posts: 10
Default BeforeClose event - Savings

I want to save a copy of a spreadsheet in a different location, after I
update it. I put code in the BeforeClose event, so it saves the file in the
desired location.

The problem I have is it saves the BeforeClose event also. Is there anyway
to make a backup copy of the file and not include the code in the backup
copy?