How do I change excel buttons with macros?

I have a spreadsheet with 5 buttons. The macros attached to the buttons shift columns around, and distort the buttons. What code can I use in the macros themselves to automatically re-size and re-locate the buttons to where I want them? (I tried recording the actions needed, but no macro code appeared). (Button name example: “All_Info”)