Tools > Protection > Protect Sheet works on the individual active sheet.
Each sheet can have its own password.

It's not too hard to crack this password, or to use formulas to retrieve
the values in protected sheets.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


Pasko1 wrote:

> Can I set different tabs in a workbook to have a different password. I'd
> like to be able to distribute a single workbook to a group of sales reps and
> I don't want them to see each other's information.