Macro gets disabled when we open .xlsm (Macro Enabled Workbook)

[Jaydeep]

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.

 

[Cindy M.]

Hi =?Utf-8?B?SmF5ZGVlcA==?=,

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.

Since you haven't gotten a response here, try in the specialized Excel
newsgroup:

http://msdn.microsoft.com/newsgroups/default.aspx?dg=microsoft.public.excel.pro
gramming&lang=en&cr=US

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail

 

[Jaydeep]

After lots of experimentation and configuration and code change I found that
if workbooks are locked and we save it as macro enabled worksheet and reopen
it again then only macros gets disabled. If workbooks are not locked and then
user save it with macro enabled workshett and reopen then it works fine.