View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JE McGimpsey JE McGimpsey is offline
external usenet poster
 
Posts: 4,624
Default Limiting Number of Times a Workbook can be Opened

In article ,
Dan R wrote:

Is there a way to limit the number of times a workbook can be opened? The
idea is to update a spreadsheet (workbook) template every few months. I
would like to control the primary workbook and have the older workbooks
implode after using it 5 or 10 times.


One could include some VBA code to do this, but it's useless if the
workbook is opened with Security set to High (or with the Shift key
down).

Is there a way to restrict the spreadsheet from being forwarded as an
attachment?


No