I maintain a master Excel file used by a team. I keep an original of this file as a backup, and I put a copy in the team folder.
Sometimes a team member opens this file in the team folder, make changes, and accidentally save the changes. That potentially creates an issue for the next user who would make a copy of this file and save it to their own folder to work on it, but not realise data has been left in the workbook from the previous user.
I am trying to think up a way or code that can resolve the issue.
I was thinking of using SheetChange or Open event (e.g. upon detecting any change other than save as a new file in a different location). With that I ran into another issue. How do I ensure the event will not interfere with other events that exist in the workbook or in the subsequent workbook?
I would keep the master copy well hidden from them.
Then, consider putting passwords on sheets they MUST not change.
Or, consider sub-master files for the detail that each team can change and then your master file can link to those sub-files to get the latest data.
I had a project to manage that had 6 team members. Gave them each their own file and linked to their data. Also passworded the functions so they could not change or delete them.