ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Worksheet Security (https://www.excelbanter.com/excel-discussion-misc-queries/101846-worksheet-security.html)

babygoode

Worksheet Security
 

I have a master workbook with about 10 different worksheets in all for
different people. I want to give people access to their own worksheet
but nobody else's - is there any way of linking the worksheet to
another excel workbook so the people can only see their own data.

Hope that make sense


--
babygoode
------------------------------------------------------------------------
babygoode's Profile: http://www.excelforum.com/member.php...o&userid=26109
View this thread: http://www.excelforum.com/showthread...hreadid=565905


Dave Peterson

Worksheet Security
 
Excel's worksheet protection is not made for this kind of security. It is
easily broken. If you don't want the information getting out, don't put it in
excel. (Or don't share that file!)

babygoode wrote:

I have a master workbook with about 10 different worksheets in all for
different people. I want to give people access to their own worksheet
but nobody else's - is there any way of linking the worksheet to
another excel workbook so the people can only see their own data.

Hope that make sense

--
babygoode
------------------------------------------------------------------------
babygoode's Profile: http://www.excelforum.com/member.php...o&userid=26109
View this thread: http://www.excelforum.com/showthread...hreadid=565905


--

Dave Peterson


All times are GMT +1. The time now is 05:15 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com