<div>
Not possible without installling &quot;keylogger&quot; software.
</div>


<div>
&quot;Keylogging&quot; has nothing to do with it.<br />
<br />
The short answer is that yes, almost certainly you can do this.<br />
<br />
The catch, of course, is two-fold:<br />
<br />
1) If macros are not enabled, it will not work, and depending on Group Policy the end user may have some control over that<br />
<br />
2) The password protection offered by Excel here (protecting worksheets + workbook structure, protecting VBA project) is extremely weak, and can be hacked in seconds using cheap and readily available tools.<br />
<br />
Still interested?
</div>


<div>
Like matthew has said this is likely to be possible, but why 140 checkboxes?<br />
<br />
What is it you are actually logging?<br />
<br />

</div>


<div>
Thank you Matthewspatric and imnorie.<br />
I always knew it would be possible and i suspected that it could be hacked by competent people.<br />
The operatives that will be ticking the boxes are play centre operatives and the manager informs me that both ability levels and interest are low. It's more a manual operative environment so the likelihood of suffucient skill is very low and the benefits relatively minor.<br />
There are so many checkboxes because each one indicates a task done. There are 20 tasks and they are done daily for health and safety reasons like checking of fridge temperatures etc, so the records are required to be kept by law. The main current issue is that there are mountains of unfiled illegible paper that continues to build, so I have been requested to provide this spreadsheet so they can indicate that they have done the check and the time it was done.<br />
Thanks<br />

</div>


<div>
Based on your description, I am thinking that you would ultimately be better off implementing this as an intranet tool. &nbsp;This has a major advantage: it keeps all of the data in a central store at every step of the process, and that data store can be secured.<br />
<br />
It may require more work up front to get started, but long term I think it is the way to go.
</div>


<div>
I had a brain fart. check the file attachment.<br />
<a href="https://filedb.experts-exchange.com/incoming/2010/09_w38/347853/TimestampCkb.xls" target="_blank" class="file-inline" title="Time stamped checkbox (46 KB)"><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 512 512"><path d="M67.508 468.467c-58.005-58.013-58.016-151.92 0-209.943l225.011-225.04c44.643-44.645 117.279-44.645 161.92 0 44.743 44.749 44.753 117.186 0 161.944l-189.465 189.49c-31.41 31.413-82.518 31.412-113.926.001-31.479-31.482-31.49-82.453 0-113.944L311.51 110.491c4.687-4.687 12.286-4.687 16.972 0l16.967 16.971c4.685 4.686 4.685 12.283 0 16.969L184.983 304.917c-12.724 12.724-12.73 33.328 0 46.058 12.696 12.697 33.356 12.699 46.054-.001l189.465-189.489c25.987-25.989 25.994-68.06.001-94.056-25.931-25.934-68.119-25.932-94.049 0l-225.01 225.039c-39.249 39.252-39.258 102.795-.001 142.057 39.285 39.29 102.885 39.287 142.162-.028A739446.174 739446.174 0 0 1 439.497 238.49c4.686-4.687 12.282-4.684 16.969.004l16.967 16.971c4.685 4.686 4.689 12.279.004 16.965a755654.128 755654.128 0 0 0-195.881 195.996c-58.034 58.092-152.004 58.093-210.048.041z"/></svg>TimestampCkb.xls</a>
</div>


TimestampCkb.xls

<div>
I like using a form like this, it's a cleaner interface.<br />
<a href="https://filedb.experts-exchange.com/incoming/2010/09_w38/347861/TimestampCkb.xls" target="_blank" class="file-inline" title="User form  (49 KB)"><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 512 512"><path d="M67.508 468.467c-58.005-58.013-58.016-151.92 0-209.943l225.011-225.04c44.643-44.645 117.279-44.645 161.92 0 44.743 44.749 44.753 117.186 0 161.944l-189.465 189.49c-31.41 31.413-82.518 31.412-113.926.001-31.479-31.482-31.49-82.453 0-113.944L311.51 110.491c4.687-4.687 12.286-4.687 16.972 0l16.967 16.971c4.685 4.686 4.685 12.283 0 16.969L184.983 304.917c-12.724 12.724-12.73 33.328 0 46.058 12.696 12.697 33.356 12.699 46.054-.001l189.465-189.489c25.987-25.989 25.994-68.06.001-94.056-25.931-25.934-68.119-25.932-94.049 0l-225.01 225.039c-39.249 39.252-39.258 102.795-.001 142.057 39.285 39.29 102.885 39.287 142.162-.028A739446.174 739446.174 0 0 1 439.497 238.49c4.686-4.687 12.282-4.684 16.969.004l16.967 16.971c4.685 4.686 4.689 12.279.004 16.965a755654.128 755654.128 0 0 0-195.881 195.996c-58.034 58.092-152.004 58.093-210.048.041z"/></svg>TimestampCkb.xls</a>
</div>


<div>
Than you briangochnauer<br />
I downloaded the code but I get the error<br />
cannot run the macro &quot;TimestampCkb(1).xls!Check<wbr />Box1_Click<wbr />, the macro may not be available in this workbook or all macros may be disabled<br />
I have tried all macro security settings including enable all macros but to no avail, so I am assuming something is missing in this sheet<br />
Thanks<br />

</div>


<div>
<br />
Then you'll have to create the macro; <br />
Open a sheet insert a checkbox on it; <br />
Right-click on checkbox then click 'Format Control' then choose 'Control' tab<br />
In 'Cell Link' type <b>$H$1,</b> &nbsp;click 'OK'<br />
<br />
Right-click on the checkbox and 'Assign Macro' click 'Record'<br />
Insert &nbsp;(Bold );<br />
<br />
Sub CheckBox1_Click()<br />
<b> &nbsp; &nbsp; If CheckBox1 &nbsp;Then<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Worksheets(1).Range(&quot;I1&quot;).<wbr />Value = Now</b><br />
&nbsp; &nbsp; &nbsp;<b>End If<br />
</b>End Sub<br />
<br />
Of course the worksheet range storing the value could be any sheet even a hidden sheet.<br />

</div>


<div>
You could actually do it without using a macro (simplify) by <br />
Right-click on checkbox then click 'Format Control' then choose 'Control' tab<br />
In 'Cell Link' type $H$1, &nbsp;click 'OK'<br />
then in cell i1 use the formula &nbsp; &nbsp; &nbsp;=IF(H1=TRUE,NOW(),&quot;&quot;)<br />
<br />
<a href="https://filedb.experts-exchange.com/incoming/2010/09_w38/348769/ClipXLS.jpg" target="_blank" class="file-inline" title="Cell Formula (18 KB)"><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 512 512"><path d="M67.508 468.467c-58.005-58.013-58.016-151.92 0-209.943l225.011-225.04c44.643-44.645 117.279-44.645 161.92 0 44.743 44.749 44.753 117.186 0 161.944l-189.465 189.49c-31.41 31.413-82.518 31.412-113.926.001-31.479-31.482-31.49-82.453 0-113.944L311.51 110.491c4.687-4.687 12.286-4.687 16.972 0l16.967 16.971c4.685 4.686 4.685 12.283 0 16.969L184.983 304.917c-12.724 12.724-12.73 33.328 0 46.058 12.696 12.697 33.356 12.699 46.054-.001l189.465-189.489c25.987-25.989 25.994-68.06.001-94.056-25.931-25.934-68.119-25.932-94.049 0l-225.01 225.039c-39.249 39.252-39.258 102.795-.001 142.057 39.285 39.29 102.885 39.287 142.162-.028A739446.174 739446.174 0 0 1 439.497 238.49c4.686-4.687 12.282-4.684 16.969.004l16.967 16.971c4.685 4.686 4.689 12.279.004 16.965a755654.128 755654.128 0 0 0-195.881 195.996c-58.034 58.092-152.004 58.093-210.048.041z"/></svg>ClipXLS.jpg</a>
</div>


ClipXLS.jpg

<div>
gave enough information to solve what was asked so I am happy
</div>


<div>
<div class="content wysiwyg-content">
Hi<br />
<br />
I have never programmed in excel but have lots of programming with Delphi, and have been given a problem of logging the time a particular checkbox was ticked.<br />
<br />
This will apply to about 140 individual checkboxes and ideally the results need to be in a password protected area, so the person doing the ticking can't mess with the result<br />
<br />
thanks
</div>
</div>


Hi

I have never programmed in excel but have lots of programming with Delphi, and have been given a problem of logging the time a particular checkbox was ticked.

This will apply to about 140 individual checkboxes and ideally the results need to be in a password protected area, so the person doing the ticking can't mess with the result

thanks

Excel Spreadsheet - log time of click of checkbox

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.