You might just close the workbook from the Workbook Open event if it's
expired. And password protect the VB project. That's easier than trying to
modify your own code. Still if macros are disabled the workbook will open
just fine.

--
Jim
"Steph" wrote in message
...
| How about this - In an open even macro, if the date the code is run the
| date of expiration, then delete a critical line of code from the
procedure,
| and then delete the open event macro. So basically this renders the code
| useless, and I will know the line of ode that was removed. Possible?
|
| "Jim Rech" wrote in message
| ...
| You cannot lock out a savvy user. Macros can be disabled and locked VB
| projects can be gotten into.
|
| --
| Jim
| "Steph" wrote in message
| ...
| | Hello. Is there a relatively fool-proof way of preventing code within
a
| | file from working after a specific date?
| | Basically, like a licensing expiration. After the initial period is
| over,
| I
| | want the file to stop working...but in such a way that a somewhat
savvy
| | programmer could not go in and, for example, remove a line in the code
| that
| | prevents the macro from firing.
| |
| | I was thinking an open_event that checks the date, and prevents the
file
| | from even being open? I don't know...I'm grasping here. Any ideas?
| | Thanks!!
| |
| |
|
|
|
|