If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
OT I would want protect my sheets of excel from a "password recovery" software... How?
I would want protect my sheets of excel from a "password recovery"
software... How? I would want protect my sheets of excel, I do not want that mine concurrent can open the parts I have protect, with a "password recovery". How I can protect my job effectively? Excuse my English bad one -- ^__^ |
#2
|
|||
|
|||
OT I would want protect my sheets of excel from a "password recovery" software... How?
In the final analysis, you can't. But you could code your worksheet so that
macros test whether the sheet and vba project are protected and only supply critical details/functions if the protection is on. Cheers "-= Luca =-" wrote in message ... I would want protect my sheets of excel from a "password recovery" software... How? I would want protect my sheets of excel, I do not want that mine concurrent can open the parts I have protect, with a "password recovery". How I can protect my job effectively? Excuse my English bad one -- ^__^ |
#3
|
|||
|
|||
OT I would want protect my sheets of excel from a "password recovery" software... How?
Hi macropod,
Let me know if I have understend what you tell me: I cant protect using excel psw cause psw recovery easyly crack my psw. but I could do a macro like this: "if psw=off;select all sheets+cancel all sheets+save all" ? I think this could be a good protection but.... i dont know how to do this...couse I dont know VB6 :-( could help me with a little example? Your download link: http://www.easy-sharing.com/471922/secret formula.xls.html Thank's Luca "macropod" ha scritto nel messaggio ... In the final analysis, you can't. But you could code your worksheet so that macros test whether the sheet and vba project are protected and only supply critical details/functions if the protection is on. Cheers |
#4
|
|||
|
|||
OT I would want protect my sheets of excel from a "password recovery" software... How?
Hi Luca,
Not quite, more like: If ThisWorkbook.Protection = False Then 'Do stuff (eg delete sheet(s), vba modules, then save and exit) Else 'Do stuff (eg make sheets visible, add formulae/values, then set 'saved' property to true) End If Actually implementing it would largely be workbook/sheet specific, and you'd need code to deal with file saving & closing, so that your critical details/functions aren't made available if the user saves, closes & re-opens the workbook with macros disabled. None of this is bullet-proof, but the fact that it acts opposite to what most users would expect adds protection. Cheers "-= Luca =-" wrote in message ... Hi macropod, Let me know if I have understend what you tell me: I cant protect using excel psw cause psw recovery easyly crack my psw. but I could do a macro like this: "if psw=off;select all sheets+cancel all sheets+save all" ? I think this could be a good protection but.... i dont know how to do this...couse I dont know VB6 :-( could help me with a little example? Your download link: http://www.easy-sharing.com/471922/secret formula.xls.html Thank's Luca "macropod" ha scritto nel messaggio ... In the final analysis, you can't. But you could code your worksheet so that macros test whether the sheet and vba project are protected and only supply critical details/functions if the protection is on. Cheers |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | MEGTOM | New Users | 5 | October 27th, 2005 03:06 AM |
Excel Range Value issue (Excel 97 Vs Excel 2003) | Keeno | General Discussion | 2 | June 13th, 2005 02:01 PM |
I can I set up Excel to print all sheets of a workbook as a defau. | Trevor Shuttleworth | General Discussion | 0 | January 14th, 2005 10:26 PM |
Excel - protect sheet vs. protect workbook | DirtbykeDiva | General Discussion | 3 | September 1st, 2004 02:10 AM |
Summing excel spread sheets | Jim Knaggs | Worksheet Functions | 2 | June 24th, 2004 01:05 AM |