asked on 1/28/2019

Making a shift list dependant on staff password.

I would like to have a randomized password on the staff list for each staff. And on the Shift list tab can we have it so depending on what password is put in, it would populate all the shifts that were in between the start and end dates of that are inputted above. if they are not working a day then that day would state "Off". Is this possible? This way the staff can print out their schedule or just view it
29133839a.xlsm

VBA Microsoft Excel Microsoft Office

Last Comment

Max Hersey

1/29/2019

Martin Liss

1/28/2019

What do you mean by "randomized password"? By "for each staff" are you implying that there would be the 3 columns on the Staff List for every staff member? Should Employee1 be able to see Employee2's data on that sheet?

Max Hersey

1/28/2019

ASKER

So i meant that the staff password would be on the staff tab. I would tell everyone their passwords and when they open the excel sheet they could put their password in and the time frame that they want to see their shifts and then it would populate a schedule of shifts for that person. The password is so that they cant see what other people are scheduled for.

Martin Liss

1/28/2019

Another way to do it if they all use different PCs or the same PC with different logins, would be to use their user name (which is stored in the PC). If you want to stick with the password approach I can generate random, secure, passwords like mDUMhDXG (can be any length you desire and/or can include symbols) or random words like 'sneaky llama arcana'. Let me know.

Martin Liss

1/28/2019

Try this. Go to the Shift List sheet and click the button. This is a "proof of concept" version and doesn't yet show any data. Employee1 is set up with password xxx.
29133875.xlsm

ASKER CERTIFIED SOLUTION

Martin Liss

1/29/2019