Excel 2003 / TM1 9.0 / Enable Macro Twice?

[Steve Vincent]

This has only just happened to me and doesn't seem to affect anyone else but it is driving me mad & getting in the way of some of my reporting.

When i open TM1 it asks to enable the tm1p.xla macro twice. That alone is annoying but i could live with it if excel wasn't also asking for macros in files to be enabled manually when they are opened by vba. I know its not the report or its code because other users do not have the problem, but despite the vba telling excel to ignore prompts, for me it asks anyway. This slows a report generation process from 10 mins left alone to 45 mins with me sat at the desk hitting "E" every time it opens the template. Its also causing me issues with development as i don't know what are true errors & what are just caused by this bug.

Does anyone know of any profile or settings that may cause this? I have shared this profile with another machine that has excel 2007 on it and that was when i first saw the problem, but a colleague has done the same as me and not had the same issue.

TIA

[jim wood]

We hav had a smililar issue with some users here. Re-installing excel seems to get rid of the issue,

Jim.

[Michel Zijlema]

Hi Steve,

How ar you starting the TM1 add-in? Is it automatically loading in Excel or is it loaded by double-clicking the tm1p.xla file?
Just a shot in the dark... but could it be you're doing both?

Michel

[Steve Vincent]

@Jim: never that simple tho, not here anyway. Office is embedded in the SOE so it'd mean a full rebuild of my machine. I have that as a last resort as it causes no end of other issues on my developer account.

@Michel: yeah had that before but i always ensure the add-in is not loaded on startup. Also, if it did that i'd get 2 TM1 toolbars - i'm only getting one in this case.

[Steve Vincent]

Found the cause but as yet not a viable solution. I have been told that code execution will be subject to tighter controls when we upgrade. I was put in a test group that inflicted those controls, hence why all the hassle with macros. Anyone know of ways to avoid "enable macros" prompts when opening files via VBA other than using my normal code of "Application.DisplayAlerts = False"?

[sachin]

One way to turn off the prompt is to set the macro security to low. Not only this exposes your PC to vulnerable code, chances are that it will be reset when you reboot your PC (assuming there is a group policy defined). The other alternative is to add digital signature as outlined by Microsoft over here.

There is another approach mentioned here. HTH.

[Steve Vincent]

cheers for the ideas but our IT security is tighter than a mermaids brassier

macro security cannot be altered. we cannot sign projects and any attempt to circumvent the policies via code are always foiled. i need our IT to find an amicable solution to it...