| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Expiration
I have made a spreadsheet for someone, they want to see it before I go over
there and install it but I dont want him to just steal it if I email it. Is there anyway that the sheet can expire after a number of times the sheet is opened or based on date? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel Expiration
|
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel Expiration
Add the following code to the ThisWorkBook module:
Private Sub Workbook_Open() Dim OpenCount As Integer OpenCount = GetSetting("MyApp", "Count", "OpenCount", 0) SaveSetting "MyApp", "Count", "OpenCount", OpenCount + 1 If OpenCount = 10 Then ThisWorkbook.Close SaveChanges:=False End Sub Then lock the project from viewing. After the workbook has been opened 10 times it will automaticly close. "Hamed parhizkar" wrote: I have made a spreadsheet for someone, they want to see it before I go over there and install it but I dont want him to just steal it if I email it. Is there anyway that the sheet can expire after a number of times the sheet is opened or based on date? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can I get Excel to automatically BOLD dates 30d before expiration? | New Users to Excel | |||
| Can I get Excel to automatically BOLD dates 30d before expiration? | Excel Worksheet Functions | |||
| Conditional Format for a date 1 month before Expiration in Excel 2 | Excel Worksheet Functions | |||
| How do I create an alert of expiration date in Excel? | Excel Discussion (Misc queries) | |||
| Expiration Notification in Excel | Excel Programming | |||
Hybrid Mode
