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

    how changing PlacementOrientation in cells via Automation

    karl.kechele

      Hello,

       

      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

      libApp.SaveActiveDatabase

      libApp.CloseActiveDatabase

      ---

      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