How to protect multiple sheet for different users

Vic Man · 2019-01-16T19:14:17Z

Hello house, so i have this excel workbook. in it, I have three different sheets. Sheet1, Sheet2 and Sheet3. This workbook is going to be accessed or used by four different people. Sheet1 is the master sheet (To be operated or viewed by person A & B. it is getting data from Sheet2 (Operated by person C), Sheet3 (Operated by person D). So, these are my requirements: 1. Sheet1, Sheet2 & Sheet3 should be visible to Person A & B since they are the Admin. 2. Only Sheet2 should be visible to person C. 3. Only Sheet3 should be visible to person D. Please, how can i achieve this?

Page 4 / 4 Prev

General Excel Questions & Answers

Last Post by SunnyKow 7 years ago

46 Posts

5 Users

0 Reactions

10.5 K Views

RSS

SunnyKow

(@sunnykow)

Posts: 1417

Noble Member

Hi Vic

No problem.

Sunny

Posted : 04/03/2019 10:00 pm

Page 4 / 4 Prev

26 Forums
7,428 Topics
32.7 K Posts
10 Online
36.9 K Members

Forum Icons: Forum contains no unread posts Forum contains unread posts

Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed