Hi There,
I have a simple time tracker shared with my team to track their breaks. I just want that tracker to be password protected I mean once clicked on Start or Stop button only admin who knows the password can change that value. I tried to protect it with password but it is asking password every time when user clicks on start and stop.
Also, if any you have any suggestions to enhance it that will be appreciated.
Thanks & Regards,
Sameer
what value are you refering to ?only admin who knows the password can change that value
tip: you know how to extract the username , i bet you know the username of the admin also
so if they do not match then don't allow update of the value.
If solved remember to mark Thread as solved , to mark your thread as Solved select Thread Tools and click Mark thread as Solved.
I can't read the mind of my wife so then I get picture but no sound .... and then I mostly get the idea, same goes here picture your outcome and I get the idea.
Hi,
Thank you for reading my post.
What i want is whichever team member is using the tracker should not change the Start Time or End Time by simply UN-protecting the sheet. Once click on start and stop the values of time taken from system should remain same.
Ah so a full protection of the sheets but allow the buttons to do their work , and only the admin knows the password.
Put below in a fresh module and play it and protect your VBAProject with same or different password.
Please Login or Register to view this content.
Hi,
Sorry to bother you again but when i put the password and try to click on Start , it asks me the password and that i dont want share with my team.
If you have some time can you please do it for me as i am really noob in Excel.
Thank you so much for taking you your valuable time for me.
My bad , the question is asked because of the code you have under sheet1
so remove all instances of ActiveSheet.Unprotect and ActiveSheet.Protect
i try to avoid upload and downloads when posting from phone
Thanks a ton...!!!!
It is working like cheese now....
Much appreciated...
Thank you Sir...
your welcome ,
Please Select Thread Tools-> Mark thread as Solved.
is der any way where start time automatically starts if pc is ideal for more than 5 minutes and stops when log back to pc?
MehulKaria,
Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.
If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.
Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.
Ben Van Johnson
ok, i have created a new post. thank you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks