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

Need Help with Macro Security 1
Menu Macro Not Executing - Need Help 1
Macros disabled, not by security settings? 9
Quicker way to enable macros? 3
Custom ribbons dissapear when saving?!? 0
VBA word change keys 0
Macro Settings in Excel2007 1
Stumped - Problem with Macro Security settings? 10

Top