Different passwords for each tab in workbook

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.

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.

No no no, sorry. If you want someone to not see something, DO NOT put that
something in an Excel file that (s)he can access. It is not safe. Do not
give that single workbook to anyone. Split it up and give away only what
each user is supposed to see.

HTH. Best wishes Harald

"Pasko1" <Pasko1@discussions.microsoft.com> skrev i melding
news:B0FE0733-78C0-49B8-B84E-166A93EE0A96@microsoft.com...
> 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.