I am looking at a way to make 1 cell (or a bunch of cells) static, using Excel VBA. In TM1 Perspectives, this wasn't an issue. Something like this would work:
Code: Select all
Sub test()
With ActiveCell
.Value = .Value
End With
End Sub
If the cell contains a simple DBRW, the DBRW is not overwritten, contrary to what happens in Perspectives.
So I figured a few workarounds, including:
Code: Select all
Sub test()
Dim z As Variant
With ActiveCell
z = .Text
.ClearContents
.Value = z
End With
End Sub
I do see the idea of being able to paste data over DBRWs without erasing them and I like that. However we should also be able to do what I’m trying to do here.
Did anyone succeed ? Thanks !