Sorry, it took me so long to get back. Took that family out for dinner.
Nothing happens when I press Save - other than the file is saved as is. I assume you tried this macro in the workbook I sent you and it must have worked or you wouldn't have suggested the solution to me. This is a puzzler. Are you using 2013 or a different version? Won't visit this again until tomorrow. Have a nice night.