Cen an Excel file be set up to no longer open after a certain date????

B

Blah

Any help would be very much appreciated.

Is there a way to set up an excel file to not open after a certain
date or after a certain amount of time?

Thank you in advance!!

Lou
 
S

ScalarSys

Blah said:
Any help would be very much appreciated.

Is there a way to set up an excel file to not open after a certain
date or after a certain amount of time?

Thank you in advance!!

Lou

This could be done with a VBA Macro but you would have to take security
measures to keep the user from tampering with the code. Maybe even
incoporate code that deletes all of the data included in the file after
a certain date. Security measures can be a hassle in real-life
environments because of "Security Warnings", etc.

If you have experienced users or can train them than this is a
possibility.
 
G

Guest

To answer your question, Yes it can be done. But, as a practical matter, it
will only keep the honest people honest. A competent Excel user can get in
to just about any file they really want to.

hth
Vaya con Dios,
Chuck, CABGx3
 
G

Guest

It can be done with code, BUT, if you disable macros on your machine then the
code cannot run and the file is accessible.
 

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

Top