Hi
Need macro to create a checklist which has following format
Sr no Activity Maker Checker
Sr no and activity will be fixed upto 20 activities. When maker clicks cell/button for any activity in maker column in front of any activity, it should capture it's windows id and time of click in that cell. Similarly, when checker does it, it should capture checker windows id and time.
At the bottom there should be button as sign off for the day which freezes checklist and saves at designated path with date.
Best
Tumbad
Need macro to create a checklist which has following format
Sr no Activity Maker Checker
Sr no and activity will be fixed upto 20 activities. When maker clicks cell/button for any activity in maker column in front of any activity, it should capture it's windows id and time of click in that cell. Similarly, when checker does it, it should capture checker windows id and time.
At the bottom there should be button as sign off for the day which freezes checklist and saves at designated path with date.
Best
Tumbad