Password

  • Thread starter Thread starter Gitano
  • Start date Start date
Gitano said:
Is there any way to protect some worksheets with a pasword that can not be
breaked?
Click to expand...

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.
 
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

Similar Threads

Break a forgotten worksheet password 3
Copying in sheet with protection with the use of a macro 5
Open password protected file with macros 2
vba solution for protection 3
Forgot Password 1
Password 3
Database Security 1
How to retrive password protected worksheet but forgot password? 1

Back
Top