How do I limit the number of times an Excel workbook can be opene.

C

Chris

I have a workbook that I send out to third parties, I want to limit its use
either by time or number of times opened- is this possible? I want to guard
against out of date data being in circulation.
 
G

Guest

hi again,
follow up:
this code will delete all data in the file after 30 days
you can add more sheets if you need. you can
increase/decrease the number of days if you like.
 
G

Guest

I don't know what is wrong with me today. I guess i am
still upset about Frank Kabel.
you are right. a hard date would be needed.
Date >= #1/18/05# + 30 then
sorry about that.
 
C

Chris

thanks guys, I cant claim to understand how to achieve it right now but I am
now looking in the right direction and will have a go! any more ideas -
especially those more closely related to my ability - greatfully recieved.
 
J

JE McGimpsey

You should realize that nothing you do will absolutely prevent a
somewhat educated user from opening or using your workbook after the
time you specify.

Using a macro is an OK idea, but if the user doesn't enable macros
(e.g., has XL's security level set to High), the macro will never fire.
A frequent suggestion is to hide your data sheet, leaving a sheet
exposed that tells the user to enable macros. Then in the Workbook_Open
event, unhide the data sheet and hide the "splash" sheet. This also
requires that you hide the data sheet in the Workbook_BeforeSave() event
(or try to prevent saving altogether).

And of course, nothing would prevent a user from copying your data and
pasting it into an unprotected workbook.
 
Top