Hi, I want to create a template with below conditions. Please help me on a code that would perform the below actions. I dunno VB as am from a commerce background. I tried my best with the help options, but unable to succeed. Kindly help me.
1) There should be two command button, 1) Start time & 2) End time.
2) When we click on the command button, it should prompt for a person name, and when we enter that persons name, it should take to the column with that persons name
3) In the row that has today's date should capture the current time in the system. the same action should be done for the End time button too.
4) As soon as the cell is filled with current time, spreadsheet should be automatically saved.
5) the cell should not be able to over-ride. It should be password protected. Only the person who knows the password should be able to over-ride the cell.
Kindly help me on this as this needs to be monitored for the break time of the processors in the project.
1)Start Time 2) End Time
Processor name June - 06- 2011 June - 07 - 2011
Start Time End Time Start Time End Time
Ajay
Sanjay
Ram
Dev
Raj
Submit an article or tip