CheckBoxes Cell link Copy & Paste problem

**turist** · 02-22-2013, 05:31 PM

In the attached file I can not copy in order the Check Box cell link values to another place.

You will see the notes and explanations in the file.

Thanks in advance for your prompt answers.

**AlphaFrog** · 02-22-2013, 11:02 PM

If you copy and paste the checkboxes to other rows below, this macro will then loop though each checkbox in the selected cells and change their linked cells to the row they are located within. Their linked cell column isn't changed.

Please Login or Register  to view this content.

**turist** · 02-23-2013, 11:14 AM

Dear AlphaFrog,
Thanks for your help.
It works as you defined. But, I want it to work automatically , without running macro,when pasted to below rows.

If possible, can you arrange a code for this kind of solution?

Thanks for your exertion.

**AlphaFrog** · 02-23-2013, 11:59 AM

How do you copy and paste rows; manually or with another macro?
Do copy\paste an entire row or just the cell with the checkboxes?

Try to explain exactly your procedure. I'm trying to understand what you mean by "automatically".

**turist** · 02-23-2013, 12:39 PM

Originally Posted by AlphaFrog

How do you copy and paste rows; manually or with another macro?
Do copy\paste an entire row or just the cell with the checkboxes?

Try to explain exactly your procedure. I'm trying to understand what you mean by "automatically".

I copy and paste the cell with the checkboxes, manually without any other macro.
When pasted the cell towards below is done I want your macro should run "automatically" . But not then.
Thanks again for your prompt reply.