View Single Post
  #3   Report Post  
Old November 5th 08, 12:55 PM posted to microsoft.public.excel.misc
Don Guillett Don Guillett is offline
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 10,124
Default "Center across selection" rather than "Merge cells"

Here is the one I use in my personal.xls assigned to a toolbar button right
next to the unmerge button

Sub CENTERACROSS()
With Selection
If .HorizontalAlignment = xlCenterAcrossSelection Then
.HorizontalAlignment = xlGeneral
Else
Selection.HorizontalAlignment = xlCenterAcrossSelection
End If
End With
End Sub

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Bob Phillips" wrote in message
...
You could easily create a macro to do it and assign it to a toolbar
button.

--
__________________________________
HTH

Bob

"Elardus" wrote in message
...
I use "Center across selection" and almost never "Merge cells", which is
generally a bad choice (across columns anyway).

I wish to add an icon or otherwsie modify the "Merge Cells" icon through
the
toolbars "Customization" process but unfortunately I cannot find "Center
across selection" amonst the "Commands - Fomat"choices.

Which means I have to do my "Cnter cross seletion"always via the menu....
Or
create an icon through a macro.

Can you please add an icon for "Center across selection" in the
"Formatting"
toolbar? Better still, don't even have the "Merge cells" icon there.
Horizontal merging leads to all kind of problems...


----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the
"I
Agree" button in the message pane. If you do not see the button, follow
this
link to open the suggestion in the Microsoft Web-based Newsreader and
then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc