Macro Level Setting

Post Reply
pradeep.k.jagadeesan
Posts: 28
Joined: Tue Jun 16, 2009 1:03 pm
OLAP Product: IBM Cognos TM1
Version: 9.5.1
Excel Version: 2007
Location: India

Macro Level Setting

Post 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
lotsaram
MVP
Posts: 3704
Joined: Fri Mar 13, 2009 11:14 am
OLAP Product: TableManager1
Version: PA 2.0.x
Excel Version: Office 365
Location: Switzerland

Re: Macro Level Setting

Post by lotsaram »

Excel Options > Trust Center > Trust Centter Settings > Trusted Locations > Add new Location
pradeep.k.jagadeesan
Posts: 28
Joined: Tue Jun 16, 2009 1:03 pm
OLAP Product: IBM Cognos TM1
Version: 9.5.1
Excel Version: 2007
Location: India

Re: Macro Level Setting

Post 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
moby91
MVP
Posts: 229
Joined: Fri Mar 11, 2011 2:18 pm
OLAP Product: TM1
Version: 9.5.1
Excel Version: 2003 2007

Re: Macro Level Setting

Post 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
Post Reply