ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Best way to secure spreadsheet (https://www.excelbanter.com/excel-programming/378169-best-way-secure-spreadsheet.html)

Don Grover

Best way to secure spreadsheet
 
I would like to give some clients an excell 2003 spreadsheet wich has
formulas and code in it.
What is the best way to secure it so only they can type in some cells ect
without being able to read the formulas.
I know nothing is secure these day given time and money, but what is the
best we can do or what options do i have.

Regards
Don Grover




JE McGimpsey

Best way to secure spreadsheet
 
The best way is to design your application as an add-in and compile it
as a COM add-in.

If you use a workbook file, anyone who can find these groups will be
able to bypass any protection:

http://www.mcgimpsey.com/excel/removepwords.html



In article ,
"Don Grover" wrote:

I would like to give some clients an excell 2003 spreadsheet wich has
formulas and code in it.
What is the best way to secure it so only they can type in some cells ect
without being able to read the formulas.
I know nothing is secure these day given time and money, but what is the
best we can do or what options do i have.



All times are GMT +1. The time now is 06:14 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com