Macro Security from 2003 to 2007

[mjp155]

Hello,

I use excel 2003 spreadsheets with macros...where my macro security is set to "medium". This setting allows all of my needed spreadsheets to work. I am working with someone who needs the same capability, but uses 2007...which has different security options.

My question is, which macro security option in 2007 is equivalent to "medium" in 2003?

Out of the options:
Disable all macros without notification
Disable all macros with notification
Disable all macros except digitally signed macros
Enable all macros (not recommended, potentially dangerous code can run)
Trust access to the VBA project object model

I assume the equivalent to be "Disable all macros with notification" ? Can someone verify this?

Thanks!

 

[xenou]

That is correct - if you choose "Disable all macros with notification" there will be a message bar at the top of the worksheet with the option to enable macros (though I think some users just don't notice it).

I also like trusted locations - if you designate a folder as "trusted", any macros in files in that folder are enabled when the workbook opens. The only thing to watch for there is: if the folder is on a network you have to click a box to "allow trusted locations on network drives"; and secondly you can allow subfolders to be trusted via another checkbox that can be checked or unchecked. It is of course unwise to make your entire C:\ drive or any large drives or folders trusted (thereby essentially trusting everything - which would defeat the purpose).