Results 1 to 4 of 4

Thread: Privacy sheet tabs
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Sep 2019
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Privacy sheet tabs

    I have a questions I hope you can help with. I have an attendance time card in excel for a group of employees. I want to create on workbook where each employee can enter their attendance and a summary sheet to gather all their time so I can submit to payroll. I know how to create and map all of that but I am looking for a way to have each employee tab data to be 'blacked out' from others who may accidentally click on another employee tab. All my sheets are locked to protect formula and formatting...help

  2. #2
    Board Regular Logit's Avatar
    Join Date
    Aug 2016
    Location
    United States
    Posts
    2,784
    Post Thanks / Like
    Mentioned
    36 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Privacy sheet tabs

    .
    You could apply a password that appears when the workbook first opens. The user can't do anything until they enter their own password,
    then only their TAB appears.

    Or ... you could create a MASTER SHEET index with the names of all the employees. By clicking on their name a password request appears
    that they must successfully complete for their TAB to appear.

    How many employees are you speaking of ?
    Last edited by Logit; Sep 8th, 2019 at 02:12 PM.

  3. #3
    New Member
    Join Date
    Sep 2019
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Privacy sheet tabs

    Quote Originally Posted by Logit View Post
    .
    You could apply a password that appears when the workbook first opens. The user can't do anything until they enter their own password,
    then only their TAB appears.

    Or ... you could create a MASTER SHEET index with the names of all the employees. By clicking on their name a password request appears
    that they must successfully complete for their TAB to appear.

    How many employees are you speaking of ?

    Hi Logit
    Thanks I will give it a whirl...20 employees but only 8 require time sheets.
    Thanks
    GAVIN

  4. #4
    Board Regular Logit's Avatar
    Join Date
    Aug 2016
    Location
    United States
    Posts
    2,784
    Post Thanks / Like
    Mentioned
    36 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Privacy sheet tabs

    .
    Have you made progress ?

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •