An issue at work with an excel spreadsheet that way too many people have access to made me think of this.
Right click a file and be able to copy the file with a time and date stamp to a sub-directory and then open the file.
I believe this would be easier done than to have to put in a macro in the spreadsheet and it could work on all files.
I am sure an AHK script would work but......everyone who accesses this file would have to run AHK which now as I think of it, creates another issue on how to make it work across a network.
Sorry about the monkey wrench at the end