Yeah, i'm trying to avoid having 2 sheets for the same project, just to avoid
clutter and confusion



"Daesthai" wrote:

I believe passwords are all or nothing. Actually that's not entirely true,
you can set one password to be able to open/view a workbook and another to be
able to edit.

One option is that you could have the totals exist in another workbook that
is password protected. It's possible to reference cells from other
workbooks, so you could have it set up so only you see that workbook with the
totals that get automatically updated as your secretary fills out the
information in the other workbook.

"Ben" wrote:

I am trying to create a profitability workbook where sheets 1-2 I want to
have my secretary fill out most of the basic data, but I don't want her to
see the profit (on worksheet 3) I make on the total project. Is there someway
to restrict viewing with a password on a specific sheet within a workbook?

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc