Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
Time restricting a file
Guys, I wonder if someone can please help me. I have a file which i only want people to be able to use for 30 days after the 1st time that they open the file. So that on the 31st day they are restricted from using the file. I'm pretty sure that this is possible, and that it may require some code but i'm not exactley sure how to do it. Do any of you excel guys out there know how to do this? Any help is greatly appreciated. Fernando -- Fernandoalberte ------------------------------------------------------------------------ Fernandoalberte's Profile: http://www.excelforum.com/member.php...o&userid=24493 View this thread: http://www.excelforum.com/showthread...hreadid=380883 |
#2
|
|||
|
|||
Hi, If you can disable a file (even if it is moved) is that enough? Or do you want to disable all instances? E.G. If you had an address book, would it be enough that they can't get to the data they have typed during the trial, even though they could start again from scratch? Or do you want them never to ba able to use the workbook and also any new, blank copies? Gaz -- gazornenplat ------------------------------------------------------------------------ gazornenplat's Profile: http://www.excelforum.com/member.php...o&userid=24494 View this thread: http://www.excelforum.com/showthread...hreadid=380883 |
#3
|
|||
|
|||
Hi there, What i'd really like to do is create a file that once the trial is over they will no longer be able to use it again. However, if this is too difficult to do then locking up the file woudl be fine. Thanks for the help Fernando -- Fernandoalberte ------------------------------------------------------------------------ Fernandoalberte's Profile: http://www.excelforum.com/member.php...o&userid=24493 View this thread: http://www.excelforum.com/showthread...hreadid=380883 |
#4
|
|||
|
|||
As a starting point for a design... * Create a sheet called "Licence" and password protect it * Create the app sheets and password protect them * In the Workbook Open event ...* Check if the registry 'Expired' value is set to true ......If it is .........put out a message .........close the worksheet ...* Check if the 'expiry date' cell is blank ......If it is .........unprotect the sheet .........set that cell to the expiry date .........protect the sheet .........save the file ...* Check if the current date/time is greater than the 'last used' cell ......If it is .........set the registry 'Expired' value to true .........put out a message .........close the worksheet ...* Unprotect the app worksheets * In the Workbook BeforeClose event ...* Password protect the app worksheets Gaz -- gazornenplat ------------------------------------------------------------------------ gazornenplat's Profile: http://www.excelforum.com/member.php...o&userid=24494 View this thread: http://www.excelforum.com/showthread...hreadid=380883 |
#5
|
|||
|
|||
Gazornenplat,
To be or not to be. -- Earl Kiosterud www.smokeylake.com/ ------------------------------------------- "gazornenplat" wrote in message news:gazornenplat.1qzvme_1119388023.5956@excelforu m-nospam.com... As a starting point for a design... * Create a sheet called "Licence" and password protect it * Create the app sheets and password protect them * In the Workbook Open event ..* Check if the registry 'Expired' value is set to true .....If it is ........put out a message ........close the worksheet ..* Check if the 'expiry date' cell is blank .....If it is ........unprotect the sheet ........set that cell to the expiry date ........protect the sheet ........save the file ..* Check if the current date/time is greater than the 'last used' cell .....If it is ........set the registry 'Expired' value to true ........put out a message ........close the worksheet ..* Unprotect the app worksheets * In the Workbook BeforeClose event ..* Password protect the app worksheets Gaz -- gazornenplat ------------------------------------------------------------------------ gazornenplat's Profile: http://www.excelforum.com/member.php...o&userid=24494 View this thread: http://www.excelforum.com/showthread...hreadid=380883 |
#6
|
|||
|
|||
2B OR NOT 2B, that is FF -- gazornenplat ------------------------------------------------------------------------ gazornenplat's Profile: http://www.excelforum.com/member.php...o&userid=24494 View this thread: http://www.excelforum.com/showthread...hreadid=380883 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Double-clicking .xls file opens Excel but doesn't open the file | Excel Discussion (Misc queries) | |||
help with date and time | Excel Worksheet Functions | |||
Time Sheets | Excel Discussion (Misc queries) | |||
Excel:I set the font color to be "Red". Next time file is open, f. | Excel Discussion (Misc queries) | |||
How do I stop Excel from closing the open file each time I open a. | Setting up and Configuration of Excel |