View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
John[_62_] John[_62_] is offline
external usenet poster
 
Posts: 16
Default 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.