Hi Anthony,
Except that in Excel 2007, if the *current* workbook does not have
macros enabled, then the macro does not run. This is regardless of
the the fact that the dialog is run from an authrorized, installed add-
in.
I don't think this is correct, for me it works without a problem.
Download my Autosafe from my site (see below), it is an addin that still uses
a dialog sheet (look on the addins tab to open the settings screen of Autosafe)
and it works.
Regards,
Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com
Member of:
Professional Office Developer Association
www.proofficedev.com