Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Mike
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default 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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How can I get a validation to run in a macro on a shared workbook? arewa Excel Discussion (Misc queries) 3 January 3rd 06 12:31 AM
shared workbook keeps locking and "unsharing" - why? Peter@TGS Excel Discussion (Misc queries) 1 August 19th 05 11:07 AM
My Shared workbook is driving me crazy!!! Paul. Excel Discussion (Misc queries) 1 April 15th 05 11:56 AM
Shared Workbook - Defining Access Rights gizmo Excel Worksheet Functions 0 January 13th 05 05:10 PM
Stubborn toolbars in Excel 007 Excel Discussion (Misc queries) 9 December 11th 04 03:02 PM


All times are GMT +1. The time now is 10:43 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"