"Mike" wrote in message
news:5o1cb.556043$YN5.374683@sccrnsc01...
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?


You can probably work around this by reopening the backup copy after it has
been saved, and then using sendkeys to activate the VBE and delete the code.
Bit tricky though.