can you auto lock a workbook after a certain date

[nplano1]

Is there any way to auto lock a workbook after a certain date and it would need a password to unlock it and use again.

Now I do have a splash screen that opens when the workbook first opens and goes away after 10 seconds

 

[Smitty]

Welcome to the Board!

Sure, you can put a static date into a hidden sheet and evaluate it in the open event. If it's passed your date then use an inputbox/userform for a password and if it doesn't pass then close the wb.

You might want to be careful about legal implications of locking people out though. It's be a topic of conversation for years and does regard weighing very seriously depending on your situation.

HTH,

 

[nplano1]

Thank you for the info not to sure what static date is as I'm new to all this but I will look it up and try. Thanks agan

 

[Smitty]

A Static Date means that you plug in your hard-entered expiration date somewhere. It just means that it's a date that's not going to change unless you change it.