| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
limiting number of uses
I have a program I am going to send for review. My question is how can I set
up the workbook to not allow access after a certain number of times the program is opened or how can i limit the number of days the program can be accessed? Thanks for you help Glenn |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
limiting number of uses
In this forum I'm likely to be spanked on this reply, but I think there are only superficial ways to do this. By superficial I mean that no matter what you come up with it can probably be hacked and easily circumvented. If all you need is a superficial way of telling a user that their input is no longer desired there are probably a lot of ways to accomplish this. You could store a number in a hidden worksheet that is incremented on open. The code could then use this as a check digit and if it is greater than your limit then display a message and exit. You could also store information in a custom document property and retrieve it to compare a drop dead date or again a counter of some sort. HTH "Glenn" wrote: I have a program I am going to send for review. My question is how can I set up the workbook to not allow access after a certain number of times the program is opened or how can i limit the number of days the program can be accessed? Thanks for you help Glenn |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
limiting number of uses
I have in the past seen an excel probram that in a few days or times the
program is run that you have to pay to us the program or it will not open. I am a novice at this...thanks for you help "XP" wrote: In this forum I'm likely to be spanked on this reply, but I think there are only superficial ways to do this. By superficial I mean that no matter what you come up with it can probably be hacked and easily circumvented. If all you need is a superficial way of telling a user that their input is no longer desired there are probably a lot of ways to accomplish this. You could store a number in a hidden worksheet that is incremented on open. The code could then use this as a check digit and if it is greater than your limit then display a message and exit. You could also store information in a custom document property and retrieve it to compare a drop dead date or again a counter of some sort. HTH "Glenn" wrote: I have a program I am going to send for review. My question is how can I set up the workbook to not allow access after a certain number of times the program is opened or how can i limit the number of days the program can be accessed? Thanks for you help Glenn |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
limiting number of uses
In a similar fashion I just want to count the number of times a file is
opened. Can you give me a little more direction on the command to "increment" when the file is opened? Thank you "XP" wrote: In this forum I'm likely to be spanked on this reply, but I think there are only superficial ways to do this. By superficial I mean that no matter what you come up with it can probably be hacked and easily circumvented. If all you need is a superficial way of telling a user that their input is no longer desired there are probably a lot of ways to accomplish this. You could store a number in a hidden worksheet that is incremented on open. The code could then use this as a check digit and if it is greater than your limit then display a message and exit. You could also store information in a custom document property and retrieve it to compare a drop dead date or again a counter of some sort. HTH "Glenn" wrote: I have a program I am going to send for review. My question is how can I set up the workbook to not allow access after a certain number of times the program is opened or how can i limit the number of days the program can be accessed? Thanks for you help Glenn |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
limiting number of uses
CB
Private Sub Workbook_Open() With Sheets("Sheet1").Range("A1") If .Value = "" Then .Value = 1 Else .Value = .Value + 1 End If End With End Sub Copy/paste into Thisworkbook module.............edit sheetanme and range to suit. Gord Dibben MS Excel MVP On Wed, 16 Jul 2008 13:29:02 -0700, CB wrote: In a similar fashion I just want to count the number of times a file is opened. Can you give me a little more direction on the command to "increment" when the file is opened? Thank you "XP" wrote: In this forum I'm likely to be spanked on this reply, but I think there are only superficial ways to do this. By superficial I mean that no matter what you come up with it can probably be hacked and easily circumvented. If all you need is a superficial way of telling a user that their input is no longer desired there are probably a lot of ways to accomplish this. You could store a number in a hidden worksheet that is incremented on open. The code could then use this as a check digit and if it is greater than your limit then display a message and exit. You could also store information in a custom document property and retrieve it to compare a drop dead date or again a counter of some sort. HTH "Glenn" wrote: I have a program I am going to send for review. My question is how can I set up the workbook to not allow access after a certain number of times the program is opened or how can i limit the number of days the program can be accessed? Thanks for you help Glenn |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
limiting number of uses
See Chip Pearson's site for "timebombing" a workbook.
Quite involved so being a novice could pose some problems implementing Chip's code and is never foolproof. http://www.cpearson.com/excel/workbooktimebomb.aspx Gord Dibben MS Excel MVP On Wed, 16 Jul 2008 11:17:11 -0700, Glenn wrote: I have in the past seen an excel probram that in a few days or times the program is run that you have to pay to us the program or it will not open. I am a novice at this...thanks for you help "XP" wrote: In this forum I'm likely to be spanked on this reply, but I think there are only superficial ways to do this. By superficial I mean that no matter what you come up with it can probably be hacked and easily circumvented. If all you need is a superficial way of telling a user that their input is no longer desired there are probably a lot of ways to accomplish this. You could store a number in a hidden worksheet that is incremented on open. The code could then use this as a check digit and if it is greater than your limit then display a message and exit. You could also store information in a custom document property and retrieve it to compare a drop dead date or again a counter of some sort. HTH "Glenn" wrote: I have a program I am going to send for review. My question is how can I set up the workbook to not allow access after a certain number of times the program is opened or how can i limit the number of days the program can be accessed? Thanks for you help Glenn |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Limiting the number of characters in a cell | Excel Discussion (Misc queries) | |||
| Limiting line number on scroll bar | Excel Discussion (Misc queries) | |||
| Limiting the number of characters in a cell. How? | Excel Discussion (Misc queries) | |||
| Limiting to one number | Excel Discussion (Misc queries) | |||
| Limiting number of instances of a workbook | Excel Programming | |||
Linear Mode
