Microsoft Excel - Macro Security Problem

Hello All, I'm having what I believe is an Excel problem but my code is in Access. When I open an Excel 2007 file (.xlsm)with a few macros in it using the double-click on the filename in its directory, the file opens without any warnings since I have the directory the file is in listed in the 'Trusted Locations' section of Excel Options. The problem arises when I open the same file in VBA code using Set objexcel = CreateObject("Excel.Application") followed by Set wbexcel = objexcel.Workbooks.Open(strSaveFile). The file opens without any warnings, but when I run one of the embedded macros in that spreadsheet, I get the 'Macros Disabled' message and I have to select the 'Allow' button to get any macros to run. I tried researching the 'Application' properties within Excel to see if the was a setting I could set on like I would with .Visible=true but I couldn't find anything that related to macro security/settings. Anyone have any ideas???
Thanks

Have you looked into the security settings in excel under the trust center tab





Don

Hi ,
It is Macro security issue , i have faced it many times.

Please reset these settings on your excel.
1. Go to Tools -> Macro -> Security
2. There you will find 2 tabs
a. Security Level
Set Security Level Low to run macro.
b. Trusted sources.
Set On for "Trust All Installed addins  and templates"
Set On for "Trust Access to Visual Basic Projects"

Hope this will resolve your problem

Hi..

The above solutions should help you out... i am sure as i also faced the same issue many times..
let me know if you still face the problem... :)

Thanks
Blue J

Its related to macro security level problem, This problem occurs ( macro disabled error) when you run any of the sample macros in the your excel file included with Microsoft Excel or Microsoft Office and you have set the security level for macros to High.
first close your file if its open
On the Tools menu, point to Macro and click Security.
In the Security dialog box, click the Security Level tab.
Click Medium and then click OK.
then run open the file

Hi Don Brown,

I am not sure if this work, please try and let me know, too.

How about this code...have you try...

Application.DisplayAlerts = False


Application.DisplayAlerts = True


pichart Y.

If none of the other suggestions solve the problem, try adding the spreadsheet's directory to Access' trusted locations.

Thanks all for your recommendations. Here's a little further explanation and what finally worked. I am using Excel 2007. The macros in the excel template in question are running from an add-in that I have located in the add-ins folder in the path c:\documentsandsettings\myuserid\application data\microsoft\addIns. If I open the template by double-clicking and run the addIn/macro, it works without issue, but if I open that same template as part of VB code in Access and try to run the same macro/AddIn, it gives the security message. I have all my development files, etc. in a "Trusted Location" including subfolders that I added when I first installed 2007. What I hadn't noticed was that the "Default AddIns" location given in the list of Trusted Locations points to the system addins location, not the user default addins folder. When I added the user default location listed above as a Trusted Location, the macros/addins run without any security message. I am still set at "Disable with Notification" in my Trust Center settings for macros, I didn't want to create any unnecessary exposures by changing that to run anything that comes by. I thank you all for your input and hope this may help someone else.
DB