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
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Logit
Well-known Member
- Joined
- Aug 31, 2016
- Messages
- 5,004
- Office Version
- 2019
- 2007
- Platform
- Windows
.
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 ?
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:
Upvote
0
Hi Logit
Thanks I will give it a whirl...20 employees but only 8 require time sheets.
Thanks
GAVIN
Upvote
0
Similar threads
- Question
