1 Reply Latest reply on Aug 12, 2010 10:40 PM by Satoru

    how changing PlacementOrientation in cells via Automation




      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