Macros gets disabled by default

[chakradhar]

My program uses office 2003 excel template and opens it up in Office 2007
excel application. When it is first exported and open all macros works fine.
User saves open excel sheet in compatibility mode (that is macro enabled).
When this saved excel sheet is opened again then Macros are disabled
automatically.

In Excel Options -> trust center -> Macro Settings -> enable all is checked
and Trust access to VBA projects is checked.
I have also added the path of saved excelsheet in Trusted locations.

What setting should we make to make sure macros will be enabled when excel
sheet is opened.

 

[Dave F]

Compatibility mode doesn't necessarily mean that macros are enabled.

Here's a good explanation of the various security settings in XL 07:
http://blogs.msdn.com/excel/archive/2006/07/28/672294.aspx

Dave