VBA in TM1 web-sheets

[manoj928]

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

[lotsaram]

Let me explain in detail.

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