Copying CheckBoxs and Linking

[slx]

Is there a way I can link checkboxes to a certain cell through VB? I'm running into a issue with excel worksheet. I'm using VB to create hard copies of worksheets to send to out to my coworkers as reports. The issue is I can't seem to copy the checkboxes and their saved states without doing a complete copy (the checkboxes are linked to a different worksheet). But when I do a complete copy, it takes everything including the references. I definitely don't want that, is there a way to make a copy of everything including the checkboxes and their saved states. Or is there a way i can just relink everything though VB, basically i'll have macro it in that it copies the sheet also where the linked cells are on.

[Leith Ross]

Hello six,

This is what I understand about your problem. You want to make copies of various worksheets that also have check boxes on them. You want the check boxes to printed whether they are are checked or not. You only want a copy of the check box and not a working check box when it is copied. Let me know if I am following you on this. Also it would help if you posted your workbook.

Thanks,
Leith Ross

[slx]

Yes that's what exactly what i'm trying to do. Unfortunately I don't know how to copy make copies of check boxes and the checked/unchecked status without it being linked into the original. I was thinking alternatively, if i could redirect the links to a different worksheet(via VB) where i can put the true/false values as constants(I know atleast how to copy sheets through value and not just reference), then i would just export the report with a extra sheet attached defining the check and unchecked status.

I'll post the workbook soon, the way i have it setup is a bit complicated, because i have 3 sheets in 1 workbook, and basically first sheet serves as the datafield, the 2nd sheet serves as the proofs which is getting references from the first sheet,the 3rd sheet with checkboxes is then linked to the 2nd sheet. When i pst, it be also great if you can identify anything that that could be simplified. I think i'm going through extra steps that might not be necessary.

[Leith Ross]

Hello slx,

Thanks for posting back. Having the workbook will certainly make this process faster and easier. I can then code a trial version for you with less delay.

Thanks,
Leith Ross

[slx]

Thanks a bunch!

I had a bit of difficulty accessing the forums yesterday night, and when i zipped the file it turned out to be 198kb, i can't use the regular attachment you have here. ~_~. I took a look at my file and i realize its already a 1.5mb xls, not sure why its taking up all the space either, but i assume it might of been while i was trying to figure out how to properly import pictures. Sorry getting side tracked, thanks again.

http://www.sendspace.com/file/dpmwdh

[Leith Ross]

Hello slx,

I downloaded your file - that's a lot of formatting. There doesn't appear to be macro to invoke copying the template. Can you walk me through how you want the template to work, so I can test it as I write the code?

Thanks,
Leith Ross