Change merge button to "center across selection"

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
 
D

Don Guillett

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

Sub CenterAcross()
Selection.HorizontalAlignment = xlCenterAcrossSelection
End Sub
 
J

JE McGimpsey

One alternative would be to replace the Merge button with the Center
Across Selection button.
 
B

Brian H

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
 
J

JE McGimpsey

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).
 
Top