Force macro security warning to be displayed
 

Hi,

This is the opposite of what is usually asked :-)

Consider the following code:-

Sub OpenWB()
Workbooks.Open "H:\temp\has macros.xls"
End Sub

The workbook 'has macros.xls' contains code that causes
the macro security warning to display if it is opened
manually (assuming that Macro Security is set to
Medium). If I run the code above the Security Warning is
NOT displayed, but I want it to be....

I have written an add-in for Excel (see
http://www.danielklann.com/excel/excel_favourites_add-
in.htm if you're interested) that acts like an Internet
Explorer favourites menu but for Excel. When opening
files I would like the add-in to act as much like Excel
as possible, including prompting the user if a file
contains macros.

Does anyone know how to do this?

For information, I'm using Excel 2003 but the solution
must work with 97 through 2003.

Thanks,
Daniel Klann