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
Macro Level Setting
-
- Posts: 28
- Joined: Tue Jun 16, 2009 1:03 pm
- OLAP Product: IBM Cognos TM1
- Version: 9.5.1
- Excel Version: 2007
- Location: India
-
- 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
Excel Options > Trust Center > Trust Centter Settings > Trusted Locations > Add new Location
-
- 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
Sorry. I Forgot to mention the MS Excel Version. Here I want this option for MS Excel 2003.
Any help?
Thanks
Pradeep J
Any help?
Thanks
Pradeep J
-
- 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
http://publib.boulder.ibm.com/infocente ... ing_N900B9
TM1 User Guide 9.5.1
Getting Started > Before You Start >
Excel Macro Security Setting
TM1 User Guide 9.5.1
Getting Started > Before You Start >
Excel Macro Security Setting