Privacy sheet tabs

gkhaleel

New Member
Joined
Sep 8, 2019
Messages
2
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
 

Excel Facts

How can you automate Excel?
Press Alt+F11 from Windows Excel to open the Visual Basic for Applications (VBA) editor.
.
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
.
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
 
Upvote 0

Forum statistics

Threads
1,213,486
Messages
6,113,932
Members
448,533
Latest member
thietbibeboiwasaco

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top