-
Hide Worksheets dependant on domain name
Good Morning,
I am am a very basic user of Excel but am trying to complete something a little more complex and am struggling quite a lot with this.
What I would like to do is have one Excel Workbook with Multiple worksheets, and then have only certain users access certain worksheets using domain login.
below is a sort of idea what I want to do.
Worksheet - Total Revenue
Worksheet - Office A
Worksheet - Office B
Worksheet - Office C
User - Joe.Bloggs logs on and can see
Worksheet - Total Revenue - Shown
Worksheet - Office A - Shown
Worksheet - Office B - Shown
Worksheet - Office C - Shown
User - Shaun Davis logs on and can see
Worksheet - Total Revenue - Hidden
Worksheet - Office A - Hidden
Worksheet - Office B - Shown
Worksheet - Office C - Hidden
I have never used VBA before so am a complete Noob. Is what I am trying to accomplish above achievable.
All help would be very much appreciated.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules