[Wonder84lalala]

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.