Rebuilding Active Forms using VBA

[eddoria]

I need to create a macro which selects a sheet and rebuilds the active form. Is this possible using VBA? We are using Excel 2003 and TM1 9.5.2

Any help with this would be greatly appreciated.

Thanks and regards

Vera Hawkins

[BigG]

I think you are after

ActiveSheet.Select
Application.Run "TM1RECALC1"

but if you search the forum you may find some better examples

[lotsaram]

I think you are after

ActiveSheet.Select
Application.Run "TM1RECALC1"

but if you search the forum you may find some better examples

In fact you would be needing Application.Run "TM1REFRESH" which is the macro to rebuild an active form. TM1RECALC1 recalculates the sheet but it will not trigger rebuilding of the rows of an active form.