TM1 Forum

Hi everyone,

I’m new using TM1 and I have a problem…

In VBA code I hide all command bars including TM1 bar in excel , but when I minimize the screen or change my window, and come back to my excel all the menus had turned back visible and unlock to my users. I have been thinking, it’s because I am using TM1 add-in with Excel (version 2010) and VBA.

Do you know something about it?

Does TM1 have any incompatibility with excel that makes my programming doesn’t work well?

What do I have to do to fix this problem?


Priscila

Edit: Moved to the TM1 forum from the bugs forum as this is not a bug registered with IBM. Admin team.

its not a problem, its the way IBM have written the Excel add-in. there is nothing you can do about it, you'll just have to live with it.

Netpartners wrote:Hi everyone,

I’m new using TM1 and I have a problem…

In VBA code I hide all command bars including TM1 bar in excel , but when I minimize the screen or change my window, and come back to my excel all the menus had turned back visible and unlock to my users. I have been thinking, it’s because I am using TM1 add-in with Excel (version 2010) and VBA.

Do you know something about it?

Does TM1 have any incompatibility with excel that makes my programming doesn’t work well?

Do you mean command bars or do you mean ribbon?

If you delete or rename tm1pRibbonX.xlam in the C:\Program Files\Cognos\TM1\bin directory then you will get the old fashion TM1 "command bars" appearing in the Add-Ins ribbon. You can then set to false either in regedit (or preferably and supposedly via script) the following keys in HKEY_CURRENT_USER\Software\Applix\TM1 Perspectives
DisplayActiveReportToolbar
DisplayDeveloperToolbar
DisplayServersToolbar
DisplaySpreadingToolbar
DisplayStandardToolbar

This should fix your issue and permanently hide all TM1 toolbars. (I can remember Alan posted some detailed instructions on how to do this. If you search you should be able to find it.)

Although quite why you would want to is another matter. (Hiding some such as servers, developer and spreading is I think beneficial and decluttering, but all?) Usually if you trust and train your users to actually use the tool you find that 1/ at times they can actually be quite capable, and 2/ using the tools that come OOTB is one hell of a lot less work and maintenance than building UIs from scratch.