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