Is it possible to disable the use of all macros when saving a workbook
except for those included in the workbook? Excel 2007 Macro Settings does
not appear to offer this, providing only the option to Enable All Macros,
which is then does not recommend. I would like to avoid having to ask users
of the application to turn this option. Would it matter that I am actually
saving the workbook in Excel 99-2003 format?

its application level, so for any instance of excel its macros are either on
or off. as far as i'm aware, its only .xlsx files (2007) that get saved
without macros





"Ted Mercer" wrote in message
...
Is it possible to disable the use of all macros when saving a workbook
except for those included in the workbook? Excel 2007 Macro Settings does
not appear to offer this, providing only the option to Enable All Macros,
which is then does not recommend. I would like to avoid having to ask
users of the application to turn this option. Would it matter that I am
actually saving the workbook in Excel 99-2003 format?

its application level, so for any instance of excel its macros are either on
or off. as far as i'm aware, its only .xlsx files (2007) that get saved
without macros





"Ted Mercer" wrote in message
...
Is it possible to disable the use of all macros when saving a workbook
except for those included in the workbook? Excel 2007 Macro Settings does
not appear to offer this, providing only the option to Enable All Macros,
which is then does not recommend. I would like to avoid having to ask
users of the application to turn this option. Would it matter that I am
actually saving the workbook in Excel 99-2003 format?