Merge and Center

That worked. 
Thanks Bob.

___________________ 
John Becker
Retail Administration
513-534-6811 
MD 1090G5
John.Becker53.com 


-----Original Message-----
From: MS Excel General Q & A List [mailto:EXCEL-GPEACH.EASE.LSOFT.COM]
On Behalf Of Bob Umlas
Sent: Tuesday, February 28, 2006 4:50 PM
To: EXCEL-GPEACH.EASE.LSOFT.COM
Subject: Re: Merge and Center

Write this macro & keep it in your Personal.xls:
  Sub CenterAcrossSelection()
    Selection.HorizontalAlignment = xlCenterAcrossSelection
End Sub
  Right-click a menu item or toolbar, select Customize
  right-click the current Merge & Center toolbar button,
select Assign
Macro, point it to CenterAcrossSelection macro (above). 
  That ought to do it!
  Bob Umlas
  Excel MVP

"Becker, John" <John.Becker53.COM> wrote:
  Excel 2000:

Can I replace the "Merge and Center" icon with
one that does "Center
Across Selection" instead?
If no icon exists, does anyone have macro code so that I can
create a
"Center Across Selection" icon?
Thanks.
___________________
John Becker
Retail Administration
513-534-6811
MD 1090G5
John.Becker53.com 



This e-mail transmission contains information that is
confidential and
may be privileged. It is intended only for the addressee(s)
named above.
If you receive this e-mail in error, please do not read,
copy or
disseminate it in any manner. If you are not the intended
recipient, any
disclosure, copying, distribution or use of the contents of
this
information is prohibited. Please reply to the message
immediately by
informing the sender that the message was misdirected. After
replying,
please erase it from your computer system. Your assistance
in correcting
this error is appreciated.

------------------------------------------------------------
------------
--
The EXCEL-G list is hosted on a Windows NT(TM) machine
running L-Soft
international's LISTSERV(R) software. For
subscription/signoff info and
archives, see htt
p://peach.ease.lsoft.com/archives/excel-g.html .
COPYRIGHT INFO:
http://peach.ease.lsoft.com/scripts/wa
.exe?SHOWTPL=COPYRIGHT&L=EXCEL-G



Bob Umlas
Excel MVP
(More frequently reads mail at rumlaskpmg.com)
		
---------------------------------
Yahoo! Mail
Bring photos to life! New PhotoMail  makes sharing a breeze.


------------------------------------------------------------
------------
--
The EXCEL-G list is hosted on a Windows NT(TM) machine
running L-Soft
international's LISTSERV(R) software.  For
subscription/signoff info and
archives, see htt
p://peach.ease.lsoft.com/archives/excel-g.html .
                             COPYRIGHT INFO:
http://peach.ease.lsoft.com/scripts/wa
.exe?SHOWTPL=COPYRIGHT&L=EXCEL-G


This e-mail transmission contains information that is
confidential and may be privileged.   It is intended only
for the addressee(s) named above. If you receive this e-mail
in error, please do not read, copy or disseminate it in any
manner. If you are not the intended recipient, any
disclosure, copying, distribution or use of the contents of
this information is prohibited. Please reply to the message
immediately by informing the sender that the message was
misdirected. After replying, please erase it from your
computer system. Your assistance in correcting this error is
appreciated.

------------------------------------------------------------
--------------
The EXCEL-G list is hosted on a Windows NT(TM) machine
running L-Soft
international's LISTSERV(R) software.  For
subscription/signoff info
and archives, see htt
p://peach.ease.lsoft.com/archives/excel-g.html .
                             COPYRIGHT INFO:
http://peach.ease.lsoft.com/scripts/wa
.exe?SHOWTPL=COPYRIGHT&L=EXCEL-G