How to Make check box unchangeable after it's ticked? Date/Time also needs to be stamped.

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

Hi mehmetcik. Thank you for the quick response and i appreciate you teaching me how to attach an excel file.

I've attached a sample workbook. It's a very basic timesheet that records the time an employee arrives at the office. The employee's time is recorded when the checkbox is ticked.

My problem is that when the checkbox is unticked, the time recorded (or the timestamp) goes away. So what i want done is that once the checkbox is ticked, it should not be subsequently changed so that the date and time of employee arrival is captured. Or, better yet, if there is a way to capture all of the timestamps each time the checkbox is ticked, then that would be the most ideal.

Thanks again for your help.

Ok My Friend

Firstly, Please ammend your profile to show your country. I like to know that at least about the person I am helping.

Ok

Select your developer tab and then click on visual basic a new window will open.

Select View and then project explorer, you will see a list of the open excel worbooks and thier associated sheets and macro modules.

Left click on your workbook to select it and then click on insert and then module.

Paste this code into the window that opens and close visual basic.

Please Login or Register  to view this content.

In the workbook

Delete column D, you do not need it.

Uncheck all your checkboxes

Then select the developer tab and click on design mode.

Right click on each of your checkboxes and click on assign macro, then select "Change"

When you are done select the developer tab and click on design mode.


Thats it you are ready to go.

Have a play.

My Apologies

Try this Code:-

Please Login or Register  to view this content.

I have renamed your checkboxes as Check box 1 to 7,

This allows me to use the name to find the right row.