Click here to Skip to main content
15,945,603 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
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 hlp options, but unable to suceed. 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
Updated 6-Jun-11 11:37am
Sergey Alexandrovich Kryukov 6-Jun-11 17:23pm    
If you don't know VB, what's the point of using VB.NET? On .NET all any language can be used. Why using the worst one?

1 solution

assuming you are talking about MS Office macros I would start by having a look here VSTO Developer Centre[^]
Share this answer
Member 7984620 6-Jun-11 17:38pm    
Yes ur correct. thank you very much for ur swift response.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900