Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
password protect worksheet
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
password protect worksheet
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
password protect worksheet
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: 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 -- Dave Peterson |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
password protect worksheet
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I password protect a worksheet from being deleted | Excel Discussion (Misc queries) | |||
Comparing a list to a Calendar worksheet. | Excel Worksheet Functions | |||
How to password protect hidden columns and custom views in Excel | Excel Discussion (Misc queries) | |||
No password protect workbook box in Tools>Options>General | Excel Discussion (Misc queries) | |||
Password Protect Cells | Excel Discussion (Misc queries) |