Password

H

Harlan Grove

Gitano said:
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.
 
G

Gitano

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top