Excel sheet vs footer...

[rcloutie]

Hi there,

I have built an excel file which is used as a template. From my app, I can open the file and insert my data. All works fine.

I want to have a footer which includes somes checkboxes While standard excel's footer doesn't support it, I have inserted a worksheet as the footer.

So here's what I'm doing:
1- Inserting all data rows in the 'good' worksheet;
2- Select the 'temp' footer worksheet and call copy method;
3- Reselect the 'good' worksheet and call the paste method;

The problem is that checkboxes are not copied with the selection.

Any idea?

Rej Cloutier