Excel 2010 and checkbox : very slow ?

[ilive]

Hi

I wrote some times ago a macro that add checkboxes in a sheet (I found some part on the net)
On Office 2003 and 2007, no trouble at all. But in office 2010, the same macro is now very slow
here is an example that add a checkbox on 800 rows

Please Login or Register  to view this content.

it takes 220 seconds to perform the macro in Excel 2010 and only 17 seconds in Excel 2007 !
If I comment the .value, .LinkedCell and .Display3DShading lines, it only takes 12 secondes in Excel 2010 (but if one of these three lines is present in the code, the macro takes again more than 200 seconds). So it seems this part of the code has a problem ... but I'm unable to find why !

Is there another way to quickly create checkboxes and modify their properties ?

Regards

[:) Sixthsense :)]

Try this...

Please Login or Register  to view this content.

[JosephP]

add

Please Login or Register  to view this content.

before you start the loop

[ilive]

it works ! speed of the macro is now the same as the one on Excel 2007
thanks a lot for your answers