blackie42
05-22-2008, 11:38 AM
Hi,
Am designing a process checklist that will use inputboxes or userforms to 'answer' particular questions and populate cells in a sheet (things like has the payment file reconciled? Has the updated file been e-mailed?)
The user will be prompted to answer yes or no. If answer is Yes then sheet updates with date and username.
Plan to create buttons on sheet so user logs in with password (seen some code I can use on forum) What I wanted to know was by using the login details and perhaps referring to a hidden 'userlist' sheet could I also mark each 'answer' with the user who has completed the task.
If so how?
Would also like to know if its possible to 'lock' the answers so they can't be changed by any user. So say first task is already completed then the code ignores the first inputbox/userform and skips to the next task
Any help appreciated or if anyone has any good ideas. This will be a long list of tasks within the process and is a kind of audit check
thanks
Am designing a process checklist that will use inputboxes or userforms to 'answer' particular questions and populate cells in a sheet (things like has the payment file reconciled? Has the updated file been e-mailed?)
The user will be prompted to answer yes or no. If answer is Yes then sheet updates with date and username.
Plan to create buttons on sheet so user logs in with password (seen some code I can use on forum) What I wanted to know was by using the login details and perhaps referring to a hidden 'userlist' sheet could I also mark each 'answer' with the user who has completed the task.
If so how?
Would also like to know if its possible to 'lock' the answers so they can't be changed by any user. So say first task is already completed then the code ignores the first inputbox/userform and skips to the next task
Any help appreciated or if anyone has any good ideas. This will be a long list of tasks within the process and is a kind of audit check
thanks