Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Macros gets disabled by default
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Macros gets disabled by default
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/...28/672294.aspx Dave -- A hint to posters: Specific, detailed questions are more likely to be answered than questions that provide no detail about your problem. "chakradhar" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macros gets disabled by default | Excel Discussion (Misc queries) | |||
Macros are disabled . . . and they shouldn't be | Excel Discussion (Misc queries) | |||
Why the default of notification is disabled? | Excel Discussion (Misc queries) | |||
Macros are disabled | Excel Discussion (Misc queries) | |||
Macros in this project are disabled???? | Excel Worksheet Functions |