How to create Login & Log out Spread sheet in Excel with automated Attendance sheet

Hello Moses,

Did you get your answer. Can you share with me please.

Whats the password for the file you have attached here.

Thanks
Sarab

Originally Posted by moses4u

Hello...

Can anyone please help me, how to activate attendance sheet automatically if officer get logged in office. Like there are 100 PA (Process Asso.) in an office in various Department. If they are logged in Morning with their login Name, they got present for the day in attendance sheet automatically, and if PA got Absent for the day in attendance sheet automatically as i mentioned. And weekend(s) like saturday and sunday is holiday.

Moses.

@sarabjit

You have to unhide the usersheet to view the username and password.

Sorry, didnt get you. I tried to unhide, but couldnt. Can you please tell me how i can do that.

Thanks

View code, in VBA Project select USERSHEET, at the bottom of properties select sheetvisible.

found it. thanks

Hi Moses, kindly provide the password for the file.

how you find the password

Kindly provide the password of the file

You must disable your Macro option before opening the file.