Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
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) | |||
How to open a spreadsheet with Macros disabled | Excel Discussion (Misc queries) | |||
Macros in this project are disabled???? | Excel Worksheet Functions |