software

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.

ThanksNope. 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:
gt;
gt; I need to share a workbook with several people. The workbook will contain one
gt; worksheet where the user will be able to enter certain information. That
gt; worksheet will display a result based on several worksheets that I do not
gt; want these people to see.
gt;
gt; On the sensitive worksheets, I have hidden the columns containing the
gt; information that I do not want viewed. I have then password protected the
gt; worksheet. However, by simply copying the worksheet into a new workbook, the
gt; user can see all of the previously hidden and protected cells.
gt;
gt; Is there a way to really hide information from a user in a shared workbook?
gt; Also, the sharing of this workbook will not be on a network. I plan to just
gt; give these people a copy of the workbook.
gt;
gt; Thanks

--

Dave Peterson