tbli

Hi all, Here is the code to create a structure chart from range A to range C of the sheet ‘’BD’’ Here is a screenshot of the sheet ‘’BD’’ https://www.dropbox.com/s/vyik32v24dp2ysm/sheet%20BD.png?dl=0 There is the ‘’Big father‘’ in A2 which is the ‘’Boss’’ The column B states all the ‘’sub...

Dear all, I'm trying to find a way to add textbox to shape created by the code below Sub créeShape(parent, niv, Attribut, coul) hauteurshape = 48 largeurshape = 92 colonne = colonne + 1 forga.Shapes.AddShape(msoShapeRectangle, 10, 10, largeurshape, hauteurshape).Name = parent...

Dear all, I try to find a way to rearrange a structure chart Here the current image I get https://www.dropbox.com/s/25sxfbbhv1vb9pj/CUURENT%20DIISPLAY.png?dl=0 Here what I would like https://www.dropbox.com/s/pquidh4eul69mi2/Rearrange%20structure%20chart.png?dl=0 Sheet 1, In the range A2...