Automatically Enable Macro when file open.

**Jack40** · 12-20-2012, 04:16 AM

Hi all,

Is anything possible to enable macro automatically for a patricular Excel file when it open?

Regards

Jack R

**:) Sixthsense :)** · 12-20-2012, 04:50 AM

Your excel version seems to be 2003 and Set the Macro Security Setting as Low and call the macro's in on Open Event of that workbook.

**Jack40** · 12-20-2012, 04:56 AM

Hi,

Am using 2010..

Regards
Jack R

**:) Sixthsense :)** · 12-20-2012, 05:06 AM

File>>Options>>Trust Center>>Trust Center Settings>>Macro Settings>>Select Enable All Macros option button>>Ok>>Ok.

Please update your excel version in your profile.

**Jack40** · 12-20-2012, 05:19 AM

Thanks for your reply..

Actully i want a Particular file only enabled atomatically when it open. But it works for every excel file...

is anything possible to enable using code??

**:) Sixthsense :)** · 12-20-2012, 05:30 AM

VBA code not needed. Just add the folder in Trusted Locations. You won't get notification for the files added in that folder and for the rest excel will ask whether you need to enable macros.