Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
prvent viewing a workbook
Dear sir,with best regards,asking you kindly to help me by a code to prevent anyone opening my workbook after one week from starting date ,in another words ( anyone cannot open the workbook after one week without entering my password). Thanks in advance. -- tofimoon4 ------------------------------------------------------------------------ tofimoon4's Profile: http://www.thecodecage.com/forumz/member.php?userid=138 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=119540 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
prvent viewing a workbook
password protect the workbook and change the password each week.
"tofimoon4" wrote in message ... Dear sir,with best regards,asking you kindly to help me by a code to prevent anyone opening my workbook after one week from starting date ,in another words ( anyone cannot open the workbook after one week without entering my password). Thanks in advance. -- tofimoon4 ------------------------------------------------------------------------ tofimoon4's Profile: http://www.thecodecage.com/forumz/member.php?userid=138 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=119540 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
prvent viewing a workbook
tofimoon4;430307 Wrote: Dear sir,with best regards,asking you kindly to help me by a code to prevent anyone opening my workbook after one week from starting date ,in another words ( anyone cannot open the workbook after one week without entering my password). Thanks in advance.You would need to add a worksheet and make all other sheets xlveryhidden, so that if the workbook is opened with macro's dissabled they still cannot view the worksheets, then if macro's are enabled you need to pop up a userform on workbook_open with a textbox and command button. Is this what you envisaged? -- Simon Lloyd Regards, Simon Lloyd 'The Code Cage' (http://www.thecodecage.com) ------------------------------------------------------------------------ Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=119540 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
prvent viewing a workbook
Dear sir,with many thanks for your interest,i have clarification a bout this request,i have asked by a company to provide them with a full program by excel against a sum , i want to give them an experiential copy(with all details ,without any protection ) before selling ,the period for checking this copy by them is one week then the agreement should be signed . Hopping i was clear . -- tofimoon4 ------------------------------------------------------------------------ tofimoon4's Profile: http://www.thecodecage.com/forumz/member.php?userid=138 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=119540 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
prvent viewing a workbook
Simon,
xlveryhidden, so that if the workbook is opened with macro's dissabled they still cannot view the worksheets Even with macros disabled there is nothing to stop a user opening VB editor and changing the sheet to XlVisible in the properties window. The reality is that a password to open isn't bad but can easily be broken with something like passware but once the workbook is open anyone with sufficient determination and Google can do whatever they want and you can't stop them. Excel protection is designed to protect against inadvertant deletions/changes and we kid ourselves and mislead the inexperienced if we pretend otherwise. Mike "Simon Lloyd" wrote: tofimoon4;430307 Wrote: Dear sir,with best regards,asking you kindly to help me by a code to prevent anyone opening my workbook after one week from starting date ,in another words ( anyone cannot open the workbook after one week without entering my password). Thanks in advance.You would need to add a worksheet and make all other sheets xlveryhidden, so that if the workbook is opened with macro's dissabled they still cannot view the worksheets, then if macro's are enabled you need to pop up a userform on workbook_open with a textbox and command button. Is this what you envisaged? -- Simon Lloyd Regards, Simon Lloyd 'The Code Cage' (http://www.thecodecage.com) ------------------------------------------------------------------------ Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=119540 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
prvent viewing a workbook
I understand.
You want to provide potential buyers of your work a demonstration copy that will expire after a certain time This is difficult to do with Excel as the security is very easy to "crack" I suggest you follow Simon's suggestion. For the code .. just give them the smallest amount that can show what can be done .. . but not all of it, so that they need to full code for the workbook to run completely secure the VBA Project --- use as long a password as possible! it can still be broken. but if the demo has code removed, then that will not be such a big problem I'd also suggest a xlVeryHidden spreadsheet. Onto this, put the date at which you delivered the workbook. If the system date is earlier, you can force the book to close again. good luck "Patrick Molloy" wrote in message ... password protect the workbook and change the password each week. "tofimoon4" wrote in message ... Dear sir,with best regards,asking you kindly to help me by a code to prevent anyone opening my workbook after one week from starting date ,in another words ( anyone cannot open the workbook after one week without entering my password). Thanks in advance. -- tofimoon4 ------------------------------------------------------------------------ tofimoon4's Profile: http://www.thecodecage.com/forumz/member.php?userid=138 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=119540 |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
prvent viewing a workbook
Mike i am aware of the limitations with excel as i assume most people are, i was simply giving the OP suggestions as to how it can be achieved, without the first step of forcing macro's to be enabled his endeavours will be undone. To be honest i believe the OP should either convert his workbook to an exe or find another application if he is to sell his product, however, if he is to sell a product with user restriction/limitation he would be wise to first learn how to achieve these himself as maintenance will be soley down to him :) QUOTE=Mike H;430334]Simon, xlveryhidden, so that if the workbook is opened with macro's dissabled they still cannot view the worksheets Even with macros disabled there is nothing to stop a user opening VB editor and changing the sheet to XlVisible in the properties window. The reality is that a password to open isn't bad but can easily be broken with something like passware but once the workbook is open anyone with sufficient determination and Google can do whatever they want and you can't stop them. Excel protection is designed to protect against inadvertant deletions/changes and we kid ourselves and mislead the inexperienced if we pretend otherwise. Mike "Simon Lloyd" wrote: tofimoon4;430307 Wrote: Dear sir,with best regards,asking you kindly to help me by a code to prevent anyone opening my workbook after one week from starting date ,in another words ( anyone cannot open the workbook after one week without entering my password). Thanks in advance.You would need to add a worksheet and make all other sheets xlveryhidden, so that if the workbook is opened with macro's dissabled they still cannot view the worksheets, then if macro's are enabled you need to pop up a userform on workbook_open with a textbox and command button. Is this what you envisaged? -- Simon Lloyd Regards, Simon Lloyd 'The Code Cage' ('The Code Cage - Microsoft Office Help - Microsoft Office Discussion' (http://www.thecodecage.com)) ------------------------------------------------------------------------ Simon Lloyd's Profile: 'The Code Cage Forums - View Profile: Simon Lloyd' (http://www.thecodecage.com/forumz/member.php?userid=1) View this thread: 'prvent viewing a workbook - The Code Cage Forums' (http://www.thecodecage.com/forumz/sh...d.php?t=119540) -- Simon Lloyd Regards, Simon Lloyd 'The Code Cage' (http://www.thecodecage.com) ------------------------------------------------------------------------ Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=119540 |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
prvent viewing a workbook
Hi,
While not disagreeing with the other advice you have been given, the protection provided is only of use for protecting the workbook from 'honest' users making inadverdant changes. If you hope to sell your workbook then giving a copy away with this type of 'protection' is most unwise and will compromise the possibility of your selling it if the potential purchaser is inclined not to pay. But there are methods. Folow the link below http://www.cpearson.com/excel/workbooktimebomb.aspx and this one http://www.cpearson.com/excel/creatingcomaddin.aspx Mike "tofimoon4" wrote: Dear sir,with many thanks for your interest,i have clarification a bout this request,i have asked by a company to provide them with a full program by excel against a sum , i want to give them an experiential copy(with all details ,without any protection ) before selling ,the period for checking this copy by them is one week then the agreement should be signed . Hopping i was clear . -- tofimoon4 ------------------------------------------------------------------------ tofimoon4's Profile: http://www.thecodecage.com/forumz/member.php?userid=138 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=119540 |
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
prvent viewing a workbook
Dear sirs,i have seen the below code in another forum but donot understand a sentence written with ,which was (Here is one very simple method, that is far from secure, but enough for most cases). Private Sub Workbook_Open() ' Range "DateCheck" Is a named cell on XlVeryHiden Sheet. If Range("TimeCheck") < vbNullString Then ' Date has been set. 'Check date. If Range("TimeCheck") < Date - 30 Then 'Expired 'Your passord Code HERE End If Else 'Set first Open date Range("TimeCheck") = Date Me.Save End If End Sub Hopping you shall give me your advice about. -- tofimoon4 ------------------------------------------------------------------------ tofimoon4's Profile: http://www.thecodecage.com/forumz/member.php?userid=138 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=119540 |
#10
Posted to microsoft.public.excel.programming
|
|||
|
|||
prvent viewing a workbook
Tofimoon4, they are simply stating that excel's security/protection is very poor!, anyone, even you, with enough determination and google can bypass excel's security!, you must protect the vba project and you must use a method to force macro's to be enabled, there is an example here 'Code Cage Downloads - The Code Cage Forums' (http://www.thecodecage.com/forumz/lo...tid=2&linkid=3) that delete's the workbook after a certain date.....if you must go this route against advice then post back. tofimoon4;430358 Wrote: Dear sirs,i have seen the below code in another forum but donot understand a sentence written with ,which was (Here is one very simple method, that is far from secure, but enough for most cases). Code: -------------------- Private Sub Workbook_Open() ' Range "DateCheck" Is a named cell on XlVeryHiden Sheet. If Range("TimeCheck") < vbNullString Then ' Date has been set. 'Check date. If Range("TimeCheck") < Date - 30 Then 'Expired 'Your passord Code HERE End If Else 'Set first Open date Range("TimeCheck") = Date Me.Save End If End Sub -------------------- Hopping you shall give me your advice about. -- Simon Lloyd Regards, Simon Lloyd 'The Code Cage' (http://www.thecodecage.com) ------------------------------------------------------------------------ Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=119540 |
#11
Posted to microsoft.public.excel.programming
|
|||
|
|||
prvent viewing a workbook
Dear sir,when i tried to open any file from the address you have registered ,this sentence was appear (Sorry - there is nothing here to show you (no permission, all entries hidden, etc). Thank you for help and consider the request was solved. -- tofimoon4 ------------------------------------------------------------------------ tofimoon4's Profile: http://www.thecodecage.com/forumz/member.php?userid=138 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=119540 |
#12
Posted to microsoft.public.excel.programming
|
|||
|
|||
prvent viewing a workbook
tofimoon4;430383 Wrote: Dear sir,when i tried to open any file from the address you have registered ,this sentence was appear (Sorry - there is nothing here to show you (no permission, all entries hidden, etc). Thank you for help and consider the request was solved.Yes my fault, you have to go through the disclaimer gateway first here 'Code Cage Downloads - The Code Cage Forums' (http://www.thecodecage.com/forumz/local_links.php) -- Simon Lloyd Regards, Simon Lloyd 'The Code Cage' (http://www.thecodecage.com) ------------------------------------------------------------------------ Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=119540 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Viewing 2 tabs in same workbook | Excel Discussion (Misc queries) | |||
Viewing a workbook across 2 monitors | Excel Discussion (Misc queries) | |||
Viewing Multiple Sheets from Same Workbook | Excel Discussion (Misc queries) | |||
Viewing Two Sheets within One Workbook | Excel Discussion (Misc queries) | |||
Only one worksheet in a workbook is available for viewing. | Excel Discussion (Misc queries) |