I am creating an application, and wish to keep the code
totally separate (to allow upgrades) from the data
workbooks, whose sheets will contain controls. Ideally I
would use ActiveX controls for their greater flexibility.

These would require code embedded in the data workbooks,
although I can minimise this by calling functions held in
the code workbook, which must then be referenced by the
data workbook. This seems a lot of hassle. Does anyone
know if there is a better way?

Also, I understand ActiveX controls are not available in
Excel 2001 for the Mac. Are they available in more recent
versions?

And finally, is there any reason to believe that the older
forms controls will no longer be supported in future
versions of Excel?

Many thanks in advance for answers to any of these related
questions.