Timing Out Formulas

[Toro Loco]

Need Help to disable formulas after a defined time period

 

[knacksc2]

this is theorhetical:
have your macro grab the necessary formulas and code stored as text from a hidden sheet for day to day use. designate the date and time you want them to be unusable. Have the macro always check the designated date against todays date, if the time has come, then have the macro delete the formulasand the hidden sheet, and force a file save. and close excel. unless they have a backup of the file this should do the trick.

 

[Smitty]

Welcome to the Board!

Do a search for "Excel timebomb". Here's an example: Timebombing A Workbook

Just note that there are legal/ethical ramifications depending on what you do.

 

[Joyner]

Not sure what type of solution you are looking for, but you can also incorporate the TODAY or NOW Function in your formulas if you are not looking for a robust solution.