how can I lock a file after some days of using it??

B

Beatriz Alvarez

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!!
 
C

Combo

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to clear areas of a locked Doc after each use-- 0
Excel - Wich Function should I use? 1
Closing PDF file from Excel VBA (Adobe Reader, Adobe Acrobat, Browser) 0
A couple questions BEFORE using Office 365 0
How to implement two shifts per day with multiple teams 0
Merging from an Excel file with graphics 1
Password locked with macro 1
Make "File in use" message appear when 2 people open the a shared document in the same time 3

Top