Protection of Sheets

I have a workbook containing 8 different "tabs" or sheets and I wanted
to know if there is a way to protect each sheet with a password so I
can send the same spreadsheet to 8 different users but they can only
see the one that they are supposed to look at.
Any suggestions are appreciated.
Thank you all

Hi
not really possible with Excel as the in-build protection
is very weak. So I wouldn't recommend this

-----Original Message-----
I have a workbook containing 8 different "tabs" or sheets
and I wanted
to know if there is a way to protect each sheet with a
password so I
can send the same spreadsheet to 8 different users but
they can only
see the one that they are supposed to look at.
Any suggestions are appreciated.
Thank you all
.

Any other suggestions on how I may be able to do this. There is
actually a column that has sensitive information that the person may
opt to use but the other people that are sent should not look at.
Any help would be appreciated greatly, THANKS




"Frank Kabel" wrote in message ...
Hi
not really possible with Excel as the in-build protection
is very weak. So I wouldn't recommend this

-----Original Message-----
I have a workbook containing 8 different "tabs" or sheets
and I wanted
to know if there is a way to protect each sheet with a
password so I
can send the same spreadsheet to 8 different users but
they can only
see the one that they are supposed to look at.
Any suggestions are appreciated.
Thank you all
.

Could you hide all the columns in every sheet then protect each sheet
with a different password. Then all the user has to do is unprotect his
or her sheet then unhide columns.


--
hb2474
------------------------------------------------------------------------
hb2474's Profile: http://www.excelforum.com/member.php...fo&userid=4189
View this thread: http://www.excelforum.com/showthread...hreadid=262885

Securely.........

You keep the master with 8 worsksheets. Break it out into 8 new workbooks.

Send each user an individual copy of a workbook they are allowed to view.

Send each user a hard copy of their portion.

Use Ron de Bruin's Sendmail add-in to email one sheet to each user.

http://www.rondebruin.nl/sendmail.htm

Gord Dibben Excel MVP

On 28 Sep 2004 11:50:15 -0700, (NACHO) wrote:

Any other suggestions on how I may be able to do this. There is
actually a column that has sensitive information that the person may
opt to use but the other people that are sent should not look at.
Any help would be appreciated greatly, THANKS




"Frank Kabel" wrote in message ...
Hi
not really possible with Excel as the in-build protection
is very weak. So I wouldn't recommend this

-----Original Message-----
I have a workbook containing 8 different "tabs" or sheets
and I wanted
to know if there is a way to protect each sheet with a
password so I
can send the same spreadsheet to 8 different users but
they can only
see the one that they are supposed to look at.
Any suggestions are appreciated.
Thank you all
.

Passwords too easily cracked, especially worksheet passwords.

A moderately knowledgeable user can find crackers on the 'net or in these news
groups.

Gord Dibben Excel MVP

On Tue, 28 Sep 2004 14:30:17 -0500, hb2474
wrote:


Could you hide all the columns in every sheet then protect each sheet
with a different password. Then all the user has to do is unprotect his
or her sheet then unhide columns.