Thank you very much Norman, sorry for not getting back to you until
now.
Can you let me know, is it possible to change the code so that:

a) the file is only saved when the file is opened as read-write and not
read-only

and
b) can the backup copy be saved to a directory in the same file path
called \backup ?

Thanks for your help
Amy xx


--
AmyTaylor
------------------------------------------------------------------------
AmyTaylor's Profile: http://www.excelforum.com/member.php...o&userid=20970
View this thread: http://www.excelforum.com/showthread...hreadid=498631