AnsweredAssumed Answered

how changing PlacementOrientation in cells via Automation

Question asked by karl.kechele on Aug 11, 2010
Latest reply on Aug 12, 2010 by Satoru



how we can change the PlacementOrientation of a cell via Excel VBA?

We create at first a dictionary "my_cells" with all cell references, then we look for a special cell reference and call the "PlacementOrientation" method:


Set libApp = CreateObject("CellEditorAddin.CellEditorDlg")

cell = my_cells.Item(cellname)

cell.PlacementOrientation(ecelldbPlacementOrientationAnyAngTopSide) = True




But the PlacementOrientation of this cell was not changed.

Should we set all flags (enums) to "False" before we set one flag to "True" ?


Best regards

Karl Kechele