|
| 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
July 28th, 2008, 06:28 AM
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
July 28th, 2008, 07:20 AM
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
August 1st, 2008, 03:06 AM
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
August 1st, 2008, 01:23 PM
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.
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
