Alvaro

I keep a button on my toolbar to run this macro.

Toggles wrap text on/off.

Sub Wrap_Text()
With Selection
.WrapText = Not .WrapText
End With
End Sub


Gord Dibben MS Excel MVP


On Wed, 11 Oct 2006 14:12:01 -0700, Álvaro
wrote:

Hi, but I would like to have a button on the toolbar that icouyld press once
and all the selected cells would wrap text.

dou you know how?
Thans!!


"JLGWhiz" wrote:

On the menu bar: FormatCellsAlignment tab and check or uncheck the Wrap
Text box.

"Álvaro" wrote:

hi I would like to know if it is there a Wrap Text command button and/or
hotkey?
thanks all!

Álvaro