I used a tip from this forum on using the Workbook_Open event in Excel 2003
to determine if macro security levels would allow macros to execute. With
that, instructions could be provided to the users on how to change their
macro security level in order to run macros in Excel 2003.

Some of those users have converted to Excel 2007. From what I have seen of
Excel 2007, it will always open the file, but disable macros. In the
process, 2007 displays a message bar containing an option button that will
allow users to enable the macros. [I personally do not use Excel 2007, but
have seen this when watching other users. So bare with my limited
description.]

Is there a way in VBA to check to see if Excel 2007 has disabled macros? I
could then use that check to display instructions to the user on how to
enable the macros for use.

Thanks.