Excel Macro Settings

T

Ted Mercer

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?
 
P

Patrick Molloy

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macros disabled, not by security settings? 5
How to Unlock Excel Workbook protected by MACRO Password 6
Stumped - Problem with Macro Security settings? 10
How to call Excel add-in macro from a button… 1
Why show Enable/Disable macro prompt after I deleted all macros? 1
VBA referencing disappears with 2007 upgrade 1
How to run auto-open macro in Excel 2007? 3
open a workbook without running Workbook_Open macro in E2007 10

Top