Hi,

I would like to add version control to my Excel workbook by disabling the workbook after a specific date. Please let me know if you have any suggestions.

Thanks.

ScottGem

Create an autoexec VBA module that checks the date and makes it read only after a specified date.

Wonder84lalala

But it needs to be disabled, not just read-only. I was thinking along the lines of making the output dependent on a date – something like IF(Now()<=ExpirationDate,ReqAnnPrem = some calculation, 0)

Thanks for your response, Scott.

ScottGem

Read Only, Disabled, whatever. The point is you need to do it in a VBAS module that runs when you open the workbook.