Dont know much about this but, if on the first worksheet (you will hav
to select it in the auto open) on a cell out of the way you ente
=TODAY(), then format the cell by choosing number, custom and the
enter ;;; the date will be hidden, then in the auto open you will nee
something like If "A2"{enter date range here} The
workbook.protect=True.....you would have to add your own VBA passwor
and then protect the VBA from being viewd or changed.

I see it like this....if you did something like the above the whol
workbook would be locked after the certain date you could always put
msgbox "Contact Vendor, Trial Period is Over" in the auto open if th
date criteria is true.

Hope this helps....sorry not really any good at writing code...mayb
someone else can help you with the concept!

Simon

--
Message posted from http://www.ExcelForum.com