Hi:

My advice would be: don't waste your time. What people want to protect is
rarely as valuable as they think it is, and any protection in Excel can
easily be defeated by a semi-knowledgeable user.

Regards,

Vasant.

"John" wrote in message
...
HI all,
I want to set an expiry date in an excel file
(.xls/.xlt). At a certain date set, the excel file will
not be useable. I can do that in code but I guess if the
user disable the macro then it won't work.

What is the best way that I should tackle this? and how
can I force the user to Enable Macro every time the
workbook is opened?

Thanks alot for any help!!!

John.