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.
 
You must log in or register to reply here.

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

Storing and Accessing Data 1
How to bypass password when pasting FROM a protected workbook 3
Different password for different worksheet " Help !" 1
How to Store Passwords To Multiple Sheets and To Retain thatPasswords When the Workbook IS closed 1
Runtime Error '9': Subscript Out Of Range 6
Protect each worksheet individually 4
Excel Protection 2
How to hide password? 1

Back
Top