View Full Version : Disable Workbook In Excel
Wonder84lalala
Jan 2, 2008, 08:04 AM
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
Jan 2, 2008, 08:35 AM
Create an autoexec VBA module that checks the date and makes it read only after a specified date.
Wonder84lalala
Jan 2, 2008, 11:50 AM
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
Jan 2, 2008, 12:28 PM
Read Only, Disabled, whatever. The point is you need to do it in a VBAS module that runs when you open the workbook.