View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Combo[_2_] Combo[_2_] is offline
external usenet poster
 
Posts: 4
Default how can I lock a file after some days of using it??

I'll show the way. How to do, if with you...


In AutoOpen procedure write a code to unlock the workbook in same condiction
(password for example)

- After opened the first time, write the current date.
- Write a code to check the limitation from the date (date + 30 days)
- If expired, show a message, lock and close the workbook
- If not expired, lets the user try it!

In AutoClose LOCK workbook again

Remember, never close the workbook without LOCK IT!


Regards!

Eduardo




"Beatriz Alvarez" escreveu na mensagem
...
Hi there!!
Could you please help me?? I need to know if an excel
file can be locked after some days of using it.
The functionality is similar to the trial versions that
you download from internet which after 30 (commonly) you
can't use them any more.
thanks!!



---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.528 / Virus Database: 324 - Release Date: 16/10/2003