View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
macropod macropod is offline
external usenet poster
 
Posts: 329
Default time sensitive file?

Hi mepetey,

You *can* make this work through vba.

The underlying principle is to code the workbook so that it won't work unless macros are enabled. If they're disabled, all the user
gets is a blank worksheet. Enabled, your macro populates the worksheet and allows whatever user actions you want, until the workbook
expires. You might want to trap the 'Save' and 'Save As' events too, to prevent the workbook being saved with any data/formulae
available. After the expiry point passes, your code deletes everything - your activation code included.

Cheers
--
macropod
[MVP - Microsoft Word]
-------------------------

"mepetey" wrote in message ...
Is it possible to make a worksheet time sensitive? I need a worksheet to become inoperable after a given time period. Any help
greatly appreciated