I have a excel file shared with multiusers with the write permission. In case
they save the file unintentionally, I want to create a back-up file of the
original one whenever the file is opened and resaved (The back-up file should
be the old one for recovery purpose!).

Is there a function in Excel to do this or need I create a Macro?