ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Limiting Number of Times a Workbook can be Opened (https://www.excelbanter.com/excel-worksheet-functions/130517-limiting-number-times-workbook-can-opened.html)

Dan R

Limiting Number of Times a Workbook can be Opened
 
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.

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

JE McGimpsey

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


All times are GMT +1. The time now is 02:41 PM.

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