Excel 2007 Enable Macro Prompt
 

In Excel 2003 when opening a file that had macros that linked to
external documents, the user was prompted with a modal dialog box. In
Excel 2007 it is a message bar. Is there any way to make Excel 2007
act like Excel 2003 and have a modal dialog box pop up for links to
external files. Many people are missing the message bar and not
enabling the macros.
Thanks,
C