I recently found a bit of useful code in the forum that enabled me to add a button and then centered it on the activecell.
I tried unsuccessfully to find it again but I believe it was posted by Norie. The code is as follows:
ActiveSheet.Buttons.Add ActiveCell.Left, ActiveCell.Top, ActiveCell.Width, ActiveCell.Height
If you like these VB formatting tags please consider sponsoring the author in support of injured Royal Marines
It works great, but I would like to add code that would immediately activate the button just added and allow me to
format it in VBA, change the size, text, assign to a macro, etc.