Simple Excel macros for TM1

Ideas and tips for enhancing your TM1 application
Post Reply
Wim Gielis
MVP
Posts: 3105
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.0.9.18
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Simple Excel macros for TM1

Post by Wim Gielis »

Hi all,

I thought I would just share 3 of my very simple macros in my Personal macro workbook:

Code: Select all

Sub TM1activate()

    AddIns("IBM Cognos TM1 Perspectives").Installed = True

End Sub

Sub TM1deactivate()

    AddIns("IBM Cognos TM1 Perspectives").Installed = False

End Sub

Sub ToggleCalculationMode()

    With Application

        If .Calculation = xlCalculationAutomatic Then

            .Calculation = xlCalculationManual
            .CalculateBeforeSave = False

        Else

            .Calculation = xlCalculationAutomatic
            .CalculateBeforeSave = True

        End If

    End With

End Sub
I added a shortcut key to launch them. It's just to avoid the hassle of going into some of the menus in Excel.

Cheers,

Wim
Best regards,

Wim Gielis

IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
Post Reply