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.
