VBA for Organizational Chart (Filtered)

Hi the code for visible cells only is...

Selection.SpecialCells(xlCellTypeVisible).Select

To make a macro into a button, just create a shape and right click on the shape and select "Assign Macro's"