ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Set Expiry Date in exel file (https://www.excelbanter.com/excel-programming/281289-set-expiry-date-exel-file.html)

John[_62_]

Set Expiry Date in exel file
 
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.

Vasant Nanavati

Set Expiry Date in exel file
 
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.





All times are GMT +1. The time now is 07:29 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com