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.

--
Regards,
Tom Ogilvy


tholman wrote in message
...

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


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/