Gunnerp245
03-18-2007, 09:28 AM
Can Excel files be configured to request a username and password when executed?
What I have.
I have had designed a Excel workbook (called Tracker) to track document movement from office to office/ person to person. Tracker is configured as a shared file on a company server. Tracker can tell me who by name has made notations ie. date and person who received the document. This has been accomplished by giving access by username. For example; UserA signs on to his computer as UserA. Then executes Tracker via a shortcut to Tracker. Any entries he makes are attributed to UserA. However if UserB makes annotations on Tracker executed by UserA the changes are attributed to UserA. I could have UserA sign off his computer and then have UserB sign on, but this is time consuming and wastes UserA's time while UserB is annotating Tracker.
My problem.
I have some field/warehouse users that pick up documents at a location separate from their work area. They regularly 'forget' to log the documents when they return to their work area.:dunno
What I want.
I desire them to annotate Tracker at the location they retreive the documents to prevent them 'forgetting' to log the documents when they return to their work location. :think:
Gunner...
What I have.
I have had designed a Excel workbook (called Tracker) to track document movement from office to office/ person to person. Tracker is configured as a shared file on a company server. Tracker can tell me who by name has made notations ie. date and person who received the document. This has been accomplished by giving access by username. For example; UserA signs on to his computer as UserA. Then executes Tracker via a shortcut to Tracker. Any entries he makes are attributed to UserA. However if UserB makes annotations on Tracker executed by UserA the changes are attributed to UserA. I could have UserA sign off his computer and then have UserB sign on, but this is time consuming and wastes UserA's time while UserB is annotating Tracker.
My problem.
I have some field/warehouse users that pick up documents at a location separate from their work area. They regularly 'forget' to log the documents when they return to their work area.:dunno
What I want.
I desire them to annotate Tracker at the location they retreive the documents to prevent them 'forgetting' to log the documents when they return to their work location. :think:
Gunner...