TM1 Forum

Hello ALL,

I am trying to embed a VBA script in active forms which works fine in active form, but when i publish it on TM1 web, it does not work.

Let me explain in detail,

We have created an active form and there we have included a check box for each records displayed in worksheet so that if user checks it, a value will be set as TRUE/FALSE in another cell of a column. So the code i have as:

Sub test()
Dim ToRow As Long
Dim LastRow As Long
Dim MyLeft As Double
Dim MyTop As Double
Dim MyHeight As Double
Dim MyWidth As Double
'--------------------------
LastRow = Range("A65536").End(xlUp).Row
For ToRow = 1 To LastRow
If Not IsEmpty(Cells(ToRow, "A")) Then
'-
MyLeft = Cells(ToRow, "B").Left
MyTop = Cells(ToRow, "B").Top
MyHeight = Cells(ToRow, "B").Height
MyWidth = MyHeight = Cells(ToRow, "B").Width
'-
ActiveSheet.CheckBoxes.Add(MyLeft, MyTop, MyWidth, MyHeight).Select
With Selection
.Caption = ""
.LinkedCell = "C" & ToRow
End With


End If
Next
End Sub

So it works fine in active form, but not in web-sheet when published on TM1 web. So please let me where we are doing wrong.

Thanks,
Manoj

Let me explain in detail.

VBA is not supported in TM1 websheets. Suggest you read the documentation, its not like this isn't covered.