Page 1 of 1

Macro Level Setting

Posted: Tue Apr 12, 2011 11:44 am
by pradeep.k.jagadeesan
Hi,

I have set Macro level setting in Excel to Medium in a template. It is always prompting me to respond to the dialogue box.
Is there any method (VBA program / inbuilt feature) we can block this dialogue box asking this, but the template has to work in all the security level except Low?

Thanks in advance
Pradeep J

Re: Macro Level Setting

Posted: Tue Apr 12, 2011 11:56 am
by lotsaram
Excel Options > Trust Center > Trust Centter Settings > Trusted Locations > Add new Location

Re: Macro Level Setting

Posted: Tue Apr 12, 2011 1:57 pm
by pradeep.k.jagadeesan
Sorry. I Forgot to mention the MS Excel Version. Here I want this option for MS Excel 2003.

Any help?

Thanks
Pradeep J

Re: Macro Level Setting

Posted: Tue Apr 12, 2011 2:51 pm
by moby91
http://publib.boulder.ibm.com/infocente ... ing_N900B9
TM1 User Guide 9.5.1
Getting Started > Before You Start >
Excel Macro Security Setting