Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel - Protection
Dear all,
I have written my own calculation in excel and would like to send it to others. The question is instead of lock the excel sheet with password, is there any other ways to distribute with protection methods? such as time based (they can used for 30 days, or if they pay the money, they can continue .. or something like that. Regards Yian |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel - Protection
You can launch an "On_Time" event......to kick off code... -- jpendegraft ------------------------------------------------------------------------ jpendegraft's Profile: http://www.excelforum.com/member.php...fo&userid=5701 View this thread: http://www.excelforum.com/showthread...hreadid=263593 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel - Protection
do u mean put on_time event under cell change or formload?
-----Original Message----- You can launch an "On_Time" event......to kick off code... -- jpendegraft --------------------------------------------------------- --------------- jpendegraft's Profile: http://www.excelforum.com/member.php? action=getinfo&userid=5701 View this thread: http://www.excelforum.com/showthread...hreadid=263593 . |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel - Protection
All depends on how you are wishing to structure it.... If you just want an expiration, just code it under the "this workbook" object... If you are looking for a "authorization" to unlock the thing... create a form that lauches on open and request the user to key in a password...if it is the wrong one, the clock continues to tick...if it is the correct one, you unlock the workbook, and kill the form.... -- jpendegraft ------------------------------------------------------------------------ jpendegraft's Profile: http://www.excelforum.com/member.php...fo&userid=5701 View this thread: http://www.excelforum.com/showthread...hreadid=263593 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel - Protection
Any code based protection for a workbook is very weak (the user can always
disable macros). Any password protection for a workbook is weak (many password cracker programs available - many free). All that said, you can write the first use date to the registry (saveSetting and getsetting methods) and check it on each subsequent use, putting up a nag dialog. -- Regards, Tom Ogilvy "Yian" wrote in message ... do u mean put on_time event under cell change or formload? -----Original Message----- You can launch an "On_Time" event......to kick off code... -- jpendegraft --------------------------------------------------------- --------------- jpendegraft's Profile: http://www.excelforum.com/member.php? action=getinfo&userid=5701 View this thread: http://www.excelforum.com/showthread...hreadid=263593 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Data Protection Best Practice: AKA: Real Sheet Protection | Excel Discussion (Misc queries) | |||
Excel Data Protection- AKA: Sheet/Macro Password Protection | Setting up and Configuration of Excel | |||
WS Protection: Different Levels of Protection on Different Ranges | Excel Discussion (Misc queries) | |||
Cell Protection vs. Worksheet Protection | Excel Discussion (Misc queries) | |||
Worksheet protection is gone and only wokbook protection can be se | Excel Discussion (Misc queries) |