software

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 quot;I
Agreequot; 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 quot;I Agreequot; in the message pane.

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

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.

quot;Benquot; wrote:

gt; I am trying to create a profitability workbook where sheets 1-2 I want to
gt; have my secretary fill out most of the basic data, but I don't want her to
gt; see the profit (on worksheet 3) I make on the total project. Is there someway
gt; to restrict viewing with a password on a specific sheet within a workbook?
gt;
gt; ----------------
gt; This post is a suggestion for Microsoft, and Microsoft responds to the
gt; suggestions with the most votes. To vote for this suggestion, click the quot;I
gt; Agreequot; button in the message pane. If you do not see the button, follow this
gt; link to open the suggestion in the Microsoft Web-based Newsreader and then
gt; click quot;I Agreequot; in the message pane.
gt;
gt; www.microsoft.com/office/comm...lic.excel.misc

You could hide that worksheet and protect the workbook.
Format|sheet|hide
and
tools|protection|protect workbook (protect the structure)

But excel's protection won't stop her if she really wants to see that worksheet.

Ben wrote:
gt;
gt; I am trying to create a profitability workbook where sheets 1-2 I want to
gt; have my secretary fill out most of the basic data, but I don't want her to
gt; see the profit (on worksheet 3) I make on the total project. Is there someway
gt; to restrict viewing with a password on a specific sheet within a workbook?
gt;
gt; ----------------
gt; This post is a suggestion for Microsoft, and Microsoft responds to the
gt; suggestions with the most votes. To vote for this suggestion, click the quot;I
gt; Agreequot; button in the message pane. If you do not see the button, follow this
gt; link to open the suggestion in the Microsoft Web-based Newsreader and then
gt; click quot;I Agreequot; in the message pane.
gt;
gt; www.microsoft.com/office/comm...lic.excel.misc

--

Dave Peterson

Yeah, i'm trying to avoid having 2 sheets for the same project, just to avoid
clutter and confusion
quot;Daesthaiquot; wrote:

gt; I believe passwords are all or nothing. Actually that's not entirely true,
gt; you can set one password to be able to open/view a workbook and another to be
gt; able to edit.
gt;
gt; One option is that you could have the totals exist in another workbook that
gt; is password protected. It's possible to reference cells from other
gt; workbooks, so you could have it set up so only you see that workbook with the
gt; totals that get automatically updated as your secretary fills out the
gt; information in the other workbook.
gt;
gt; quot;Benquot; wrote:
gt;
gt; gt; I am trying to create a profitability workbook where sheets 1-2 I want to
gt; gt; have my secretary fill out most of the basic data, but I don't want her to
gt; gt; see the profit (on worksheet 3) I make on the total project. Is there someway
gt; gt; to restrict viewing with a password on a specific sheet within a workbook?
gt; gt;
gt; gt; ----------------
gt; gt; This post is a suggestion for Microsoft, and Microsoft responds to the
gt; gt; suggestions with the most votes. To vote for this suggestion, click the quot;I
gt; gt; Agreequot; button in the message pane. If you do not see the button, follow this
gt; gt; link to open the suggestion in the Microsoft Web-based Newsreader and then
gt; gt; click quot;I Agreequot; in the message pane.
gt; gt;
gt; gt; www.microsoft.com/office/comm...lic.excel.misc