| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Password
Is there any way to protect some worksheets with a pasword that can not be
breaked? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Password
Gitano wrote...
Is there any way to protect some worksheets with a pasword that can not be breaked? No. Internal passwords are easily broken. You could make things annoying for users who unlock worksheet by using udfs which check whether specific worksheets are protected or not and return error values if they're not protected or Empty (effectively the same value as blank cells) otherwise, then call such udfs from every formula so that all formulas return errors when any worksheets that should be protected aren't. However, there's no way to stop users from replacing your password with one of their own. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Password
Hi Thanks for your help. Sounds perfect but. hmm what is udfs? And How may I
call it from every formula. Really apreciate your help "Harlan Grove" wrote: Gitano wrote... Is there any way to protect some worksheets with a pasword that can not be breaked? No. Internal passwords are easily broken. You could make things annoying for users who unlock worksheet by using udfs which check whether specific worksheets are protected or not and return error values if they're not protected or Empty (effectively the same value as blank cells) otherwise, then call such udfs from every formula so that all formulas return errors when any worksheets that should be protected aren't. However, there's no way to stop users from replacing your password with one of their own. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Password
A UDF is a User Defined Formula.
-- David Biddulph "Gitano" wrote in message ... Hi Thanks for your help. Sounds perfect but. hmm what is udfs? And How may I call it from every formula. Really apreciate your help "Harlan Grove" wrote: Gitano wrote... Is there any way to protect some worksheets with a pasword that can not be breaked? No. Internal passwords are easily broken. You could make things annoying for users who unlock worksheet by using udfs which check whether specific worksheets are protected or not and return error values if they're not protected or Empty (effectively the same value as blank cells) otherwise, then call such udfs from every formula so that all formulas return errors when any worksheets that should be protected aren't. However, there's no way to stop users from replacing your password with one of their own. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Password | Excel Discussion (Misc queries) | |||
| How to see macro code of a password protected macro without a password? | Excel Worksheet Functions | |||
| how to automate opening a password protected excel file? e.g. a .xls that has a password set in the security tab. | Excel Worksheet Functions | |||
| bypass password when update linking of password protected file | Excel Discussion (Misc queries) | |||
| PASSWORD | Excel Worksheet Functions | |||
Hybrid Mode
