Password to access a worksheet

  • Thread starter Thread starter tholman
  • Start date Start date
T

tholman

Does anyone have a piece of simple code that will force a password to be
entered correctly to access the worksheet in the workbook?

For example, any user can access (maybe) 5 worksheets, but the others
have a password on them to protect them?

Many thanks

THolman
 
You need to put the worksheets in separate workbooks if you need to enforce
password protection.

If you continue with your current design and forget one of the passwords,
post back here and someone will post some code to break the password for
you.
 
Back
Top