Many of my users are sporadic about making back-up copies of their workbook files. These are workbooks based on a template that I built, and all use an add-in that I created and keep up-to-date. I'm trying to think of ways to "help them" make back-ups.
It's too late to put code in This Workbook for the exisiting files (but the template has been updated for new files). But I wondered if I jcould put code in the add-in that would do this? The code would have to evaluate every Excel file the user opened; if a certain named range was in the workbook, then I could simply use SaveCopyAs to make a back-up and write the date or some other "code word" into the file so it only gets done once on any given day.
If this were on my own computer, I know I could put code using the Application object in my Personal macro workbook. And I did see Chip Pearson's page on doing things like that. But I couldn't see if it could be adapted for use in an add-in.
Has anyone else done this?