Excel 2007 : Linking Checkboxes

Hello guys, I have a small problem with checkboxes. I have checkboxes in E6:K128 and want to link them to different cells each in range R6:X128. I cant link one and then drag because it links all of them to the same cell. How can I link each one to its own cell without formatting each one individually?
Thanks for the help.

Well, I found a macro that does this for you. The only thing is it makes the checkbox area much too long. How can I make the size smaller?

Please Login or Register  to view this content.