Hi all, this one is causing me a bit of a problem. Hope i get the problem across !.
I have a template which i update regularly, this template gets used daily, and files are saved from it.
Over the years we have lots of these files. People open old versions of these rather than using the new template. I want a way to stop people from opening old workbooks and doing a save as.
In the workbooks, is a date, in a cell which i update every-time i make a new revision.
The only solution I can think of, is to create a macro in a Excel Addin to check my revision date in the old workbook which is being opened, against the templates date. if the date is older, then not allow the user to save the file. I can do this using the workbook_beforesave function (I think).
Only problem is getting the new macro to run, in the old workbooks. This can be done by the Addins, but ive read that the XLA doesnt refer to the Active workbook when using the workbook_beforesave function. Is there another way todo this?
I have a template which i update regularly, this template gets used daily, and files are saved from it.
Over the years we have lots of these files. People open old versions of these rather than using the new template. I want a way to stop people from opening old workbooks and doing a save as.
In the workbooks, is a date, in a cell which i update every-time i make a new revision.
The only solution I can think of, is to create a macro in a Excel Addin to check my revision date in the old workbook which is being opened, against the templates date. if the date is older, then not allow the user to save the file. I can do this using the workbook_beforesave function (I think).
Only problem is getting the new macro to run, in the old workbooks. This can be done by the Addins, but ive read that the XLA doesnt refer to the Active workbook when using the workbook_beforesave function. Is there another way todo this?
