Hi,
What I did in a similar case is to hide the workbook that I don't want
anybody to look at and then protect the sheet, then I give the password to
the users I want to see the information. To unprotect the sheet I prepare a
macro asking for the password, however when hidding the sheet be sure that
you go far from where the information is let's say AZ1000, the reason is
because when asking for the password the sheet shows up first if the password
is incorrect it will hide again, hiding it in AZ1000 makes the user first
thing to see is that cell

if this helps please click yes

"JWhitehead" wrote:

I have a user who is running office 2007, and is trying to protect a workbook
in Excel. I know how to do this part. The question is though, is it possible
to pwd protect the viewing of only one worksheet.

Example: there are 2 pages in the workbook. Page 1 has data that everyone
can view. Page 2 has data that only some can view. Other than pwd protecting
the contents of page 2 and changing the font colour to white, is there a way
to do this?

Thank you all for your help.