Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
safe protection of sheets and vba
I'm looking for a safe protection of the content of my spreadsheets,
hiding all formulas, some calculation sheets and all vba programming effectively. Is it enough to protect by choosing the cells (by Format/ Cells/ Protection on) and activate the protection (by Extra/ Protection/ Sheets resp. Workbook). I heard that they are ways to get to the formulas anyway. For example by transferring it to another Excel version. And how to protect the vba code efficiently. Maybe somebody may give me a hint how to make sure that the Excel application can be given away, without giving away the knowhow of the programming. Thanx Siggy --- Message posted from http://www.ExcelForum.com/ |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
safe protection of sheets and vba
Addition to my question: I dont mean cracking the given password, that
another topic. I mean getting to the formulas or vba source cod through a backdoor are a transfer methode. Does anybody have a clue ... Thanx Sigg -- Message posted from http://www.ExcelForum.com |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
safe protection of sheets and vba
Geo Siggy wrote in message ...
I'm looking for a safe protection of the content of my spreadsheets, hiding all formulas, some calculation sheets and all vba programming effectively. Is it enough to protect by choosing the cells (by Format/ Cells/ Protection on) and activate the protection (by Extra/ Protection/ Sheets resp. Workbook). I heard that they are ways to get to the formulas anyway. For example by transferring it to another Excel version. And how to protect the vba code efficiently. Maybe somebody may give me a hint how to make sure that the Excel application can be given away, without giving away the knowhow of the programming. Thanx Siggy The "protect sheet" password and VBA Project password in MS Excel provides a reasonalble measure of security for everyday use. However, if somebody is determined to find the password, there are many options available - for example: http://www.intertek.org.uk |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
safe protection of sheets and vba
Formulas can be gotten by removing the worksheet passwords, see
http://www.mcgimpsey.com/excel/removepwords.html VBA source code can be accessed using commercial crackers or hex editors. In fact, with hex editors, you can view the code in the file - it's tokenized so that it's not easily human readable, but it's often easy to get the gist of the code. The most secure way to protect code is to develop compiled COM add-ins. Unfortunately, they won't work with XL97 or any Mac version. In article , Geo Siggy wrote: Addition to my question: I dont mean cracking the given password, thats another topic. I mean getting to the formulas or vba source code through a backdoor are a transfer methode. Does anybody have a clue ... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Protection on Multiple Sheets | Excel Discussion (Misc queries) | |||
Protection of many sheets | Excel Worksheet Functions | |||
help with protection of sheets | Excel Discussion (Misc queries) | |||
Applying Protection To Multiple Sheets | New Users to Excel | |||
Protection and Hiding Sheets | Excel Discussion (Misc queries) |