Change merge button to "center across selection"

  • Thread starter Thread starter Brian H
  • Start date Start date
B

Brian H

I can't find a way to assign the "center across selection" action to the
"merge" button in excel. Modify and customize didn't help.

Any ideas?

Thanks for any help!

BH
 
try assigning a custom button to this code in your personal.xls

Sub CenterAcross()
Selection.HorizontalAlignment = xlCenterAcrossSelection
End Sub
 
One alternative would be to replace the Merge button with the Center
Across Selection button.
 
Thanks for the info. Unfortunately I don't see the Center Across Selection
button to select. Could you direct me to where it is or do you have any
ideas why it would not appear?

Thanks again.
Brian
 
My apologies - I was thinking of a much earlier version. I currently
build all my toolbars using VBA, and I've had a Center Across Selection
button for so long that I forgot it wasn't native (it uses code similar
to that given in another reply).
 
Back
Top