We are noticing that large numbers of controls, such as check boxes, on
Excel 2007 worksheet fill-in forms, tend to slow down the worksheet. The
initial load and later recalculations or refreshes are slow. This leads to
two questions:

FIRST, are the 'Form Controls' or 'ActiveX Controls' more efficient? Or,
perhaps, they are both equally efficient? The thought being that a more
efficient control might retard the display refresh less.

SECOND, is there a way to prevent the controls from recalculating everytime
there is a worksheet change? Other calculations are not slowing the
worksheet, just the 100 or so controls. If possible we would like to turn
the control updates OFF until we force a manual update. Is this possible?

Thank you for any help.