I have set up coding within a sheet to create a kind of "tick box" type cell - all good! However, the sheet is set up so that the "tick box" cell needs to be put alongside tables that get pasted in from a separate sheet, thus allowing the User of the document to decide whether or not they want to accept the table.

Is there any way that the coding can be copied so that it is automatically set up once a table is pasted in. For example if i set up cell $l$2 with the coding and then wanted to input a table and then wanted the cell immediately below to be the "tick box" cell i can't just copy the cell and thus the coding across.

Is there any way to get over this issue?

Example Attached,Example for Excel Forum.xlsm