check box to lock cells, date stamp and hide itself after checking

Dear All, I have a particular worksheet with a check box which a user should check to confirm various selections made above. On checking I would like 3 things to happen.
1. Cells F7:F13 (containing outputs from combo boxes) become locked.
2. A date stamp is placed in cell I13.
3. Ideally the checkbox hides itself or locks itself.

I am using Excel2010. The Worksheet will be protected and the cells referred to are in columns which are hidden from the user.

Many thanks for any help.

What kind of Checkbox, can you attach an example workbook?

This for the controls checkbox

Please Login or Register  to view this content.

Is there just the one checkbox or many?

Where's the code? If it is not in the Sheet module then change the Me to ActiveSheet or the sheet it is running on e.g

Please Login or Register  to view this content.

The previous code was for the Controls,
This should work for the Forms Checkbox

Please Login or Register  to view this content.

You may have difficulty unchecking the box though

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

Doing this will ensure you get the result you need!

Many thanks Guys.... now it works perfectly after a few wobblies my end