How protect with password the access of a spreadsheet ?
 

Hi. I want to know how i can protect the access of non-authorized user to
view the content of one spreadsheet of all workbook.

The reason is my company has a sales report that it can be viewed for all
user but there are 1 spreadsheet that contain confidential information (in
the same workbook) that we wan't that be watched for all user of the report.

Best Regards,

Manuel

How protect with password the access of a spreadsheet ?
 

Hi,

There no good way to prevent a user to see portions-only of a book.
You could:
- hide the sheet, say sheet Confidential: menu Insert Sheet Hide
- then Lock the STructure of the book by applying a password to the
workbook: menu Tools Protection, Protect Workbook.
However, i believere that as long as a user can open the book, assuming he
knows there is a sheet called COnfidential, he could do in another sheet in a
cell:
=Confidential!A1
which would returns the values from sheet Confidential.

The safer is to distibutes books with only data that are ok for the user to
see... therefore having several distribution for several user groups.
BUt of course, it doesn't prevent a user of group A to give the file and
password to a user of group B.

Maybe someone else has a better idea.

Regards,
Sébastien

"Manuel" wrote:

Hi. I want to know how i can protect the access of non-authorized user to
view the content of one spreadsheet of all workbook.

The reason is my company has a sales report that it can be viewed for all
user but there are 1 spreadsheet that contain confidential information (in
the same workbook) that we wan't that be watched for all user of the report.

Best Regards,

Manuel

How protect with password the access of a spreadsheet ?
 

There is no way to prevent someone who has access to your workbook from
seeing everything in it. Internal protection (using VBA) can make it
difficult for novices, but anyone who can find these newsgroups can find
ways to bypass that protection.

You'll need to either trust your employees to not look, or find a
different method of distribution that doesn't include the confidential
info.

If you trust your employees, you can search the archives for lots of
inventive schemes:

http://groups.google.com/advanced_gr...ugroup=*excel*

In article ,
Manuel wrote:

The reason is my company has a sales report that it can be viewed for all
user but there are 1 spreadsheet that contain confidential information (in
the same workbook) that we wan't that be watched for all user of the report.

How protect with password the access of a spreadsheet ?
 

Manuel,

One dependable way to shield your confidential spreadsheet fro
unauthorized users is to, in addition to "hiding" as suggested,
encrypt the sheet using VBA code. This strategy comes with the need t
have a parrarel "decrypting" code. The beauty of the encrypt/decryp
artifice is that you can set your own "enrypt" key which, in the manne
of speaking, is well-nigh difficult for anyone to detect (even allowin
for the vast degree of password-breaking nous in computing). I hav
developed one such twin-codes for encrypting and decrypting and hav
been using them flawlessly with proven security. You may wish t
contact me by private mail for a copy.


davi

--
david
-----------------------------------------------------------------------
davidm's Profile: http://www.excelforum.com/member.php...fo&userid=2064
View this thread: http://www.excelforum.com/showthread.php?threadid=39505

How protect with password the access of a spreadsheet ?
 

Just for my edification, does your solution depend on the VBA code being
protected from viewing (is your algorithm asymmetrical so that knowing
the encryption coding doesn't allow you to reverse the encryption)?

What encryption method are you using? Is it a standard, such as In
article ,
davidm wrote:

Manuel,

One dependable way to shield your confidential spreadsheet from
unauthorized users is to, in addition to "hiding" as suggested,
encrypt the sheet using VBA code. This strategy comes with the need to
have a parrarel "decrypting" code. The beauty of the encrypt/decrypt
artifice is that you can set your own "enrypt" key which, in the manner
of speaking, is well-nigh difficult for anyone to detect (even allowing
for the vast degree of password-breaking nous in computing). I have
developed one such twin-codes for encrypting and decrypting and have
been using them flawlessly with proven security. You may wish to
contact me by private mail for a copy.


david