I understand.

You want to provide potential buyers of your work a demonstration copy that
will expire after a certain time

This is difficult to do with Excel as the security is very easy to "crack"
I suggest you follow Simon's suggestion.
For the code .. just give them the smallest amount that can show what can be
done .. . but not all of it, so that they need to full code for the workbook
to run completely
secure the VBA Project --- use as long a password as possible! it can still
be broken. but if the demo has code removed, then that will not be such a
big problem

I'd also suggest a xlVeryHidden spreadsheet. Onto this, put the date at
which you delivered the workbook. If the system date is earlier, you can
force the book to close again.

good luck

"Patrick Molloy" wrote in message
...
password protect the workbook and change the password each week.


"tofimoon4" wrote in message
...

Dear sir,with best regards,asking you kindly to help me by a code to
prevent anyone opening my workbook after one week from starting date ,in
another words ( anyone cannot open the workbook after one week without
entering my password).
Thanks in advance.


--
tofimoon4
------------------------------------------------------------------------
tofimoon4's Profile:
http://www.thecodecage.com/forumz/member.php?userid=138
View this thread:
http://www.thecodecage.com/forumz/sh...d.php?t=119540