"Center Across Selection" icon in excel 2003

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I miss the old icon and am not a fan of merged cells. any suggestions for
creating an icon for "center across selection" icon that does not merge cells?
 
There is no Icon for "center across selection".

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

Assign this macro to a button.


Gord Dibben Excel MVP

On Wed, 30 Nov 2005 06:06:01 -0800, no merge dan <no merge
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Center across selection 2
"Center across selection" rather than "Merge cells" 10
TOOLBAR button or Keyboard Shortcut FOR Center Across Selection?? 13
A button for Center Across Selection 4
Where is the justify function in Excel 2007? 3
"justify across selection" cell formatting 6
Windows 10 How to remove Action Center following anniversary update 6
Text Alighnment Across Selection 3

Back
Top