MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Protect Excel File

  Asked By: Madhat    Date: Jan 03    Category: MS Office    Views: 1955

I need to give an Excel file to someone and although
it is password protected but I want to apply
additional security by making sure it is not usable
after a certain date. For that purpose, I want to know
if there is any way in which we can time bound our
workbooks in MS Excel.



1 Answer Found

Answer #1    Answered By: Tarron Thompson     Answered On: Jan 03

There are many things you can do if you think about it for a while. If
you use VBA, check the current date, and if the date  is greater than
some preset date, exit the workbook.

Of course, if it was me, I would then load the workbook, disabling the
macros, and hack the date/do not execute that bit of code. And password
protecting the VBA code is not secure either, very easy to hack.

It depends on the skill level of your user. Excel is not a secure
platform, never designed to be one.

You might want to look at Microcosm. They supply CopyControl (has now
been superseded, but I have not yet upgraded). But both programs can
make an Excel file  secure, with some VBA code that looks whether an
external file is of valid state or not (the state set by expiry date, or
coded to a specific PC's hardware).

Very elegant, and on my development version, I have disabled the Call to
this procedure. Even in the distribution version, I do not use it
anymore. My VBA password  is around 50 characters, and it takes me very
little time  to crack it using a freeware utility.

So, after all that: Dependent on your users, but I would not even bother
with anything more than a simple password.

Didn't find what you were looking for? Find more on Protect Excel File Or get search suggestion and latest updates.