If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Shared Workbook Protection
I need to share a workbook with several people. The workbook will contain one
worksheet where the user will be able to enter certain information. That worksheet will display a result based on several worksheets that I do not want these people to see. On the sensitive worksheets, I have hidden the columns containing the information that I do not want viewed. I have then password protected the worksheet. However, by simply copying the worksheet into a new workbook, the user can see all of the previously hidden and protected cells. Is there a way to really hide information from a user in a shared workbook? Also, the sharing of this workbook will not be on a network. I plan to just give these people a copy of the workbook. Thanks |
#2
|
|||
|
|||
Shared Workbook Protection
Nope. There is no effective way to hide information from a user. Passwords to
protect worksheets are not made to protect intellectual property. They're made to stop users from overwriting cells with formulas. Mike wrote: I need to share a workbook with several people. The workbook will contain one worksheet where the user will be able to enter certain information. That worksheet will display a result based on several worksheets that I do not want these people to see. On the sensitive worksheets, I have hidden the columns containing the information that I do not want viewed. I have then password protected the worksheet. However, by simply copying the worksheet into a new workbook, the user can see all of the previously hidden and protected cells. Is there a way to really hide information from a user in a shared workbook? Also, the sharing of this workbook will not be on a network. I plan to just give these people a copy of the workbook. Thanks -- Dave Peterson |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Removing shared workbook protection | Thore | General Discussion | 3 | June 30th, 2005 12:11 AM |
Shared Workbook | Erika | General Discussion | 0 | February 18th, 2005 02:23 PM |
Workbook not shared but experiencing sharing problem | CM | General Discussion | 1 | November 6th, 2004 11:17 AM |
Shared Workbook Setup Guidance | WillRn | General Discussion | 2 | November 5th, 2004 01:51 PM |
Dr Watson if open a Shared Workbook | chris73 | General Discussion | 1 | July 16th, 2004 02:26 PM |