View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
jmoder jmoder is offline
external usenet poster
 
Posts: 1
Default Is there a Wrap Text command button?

Gord
This is exactly what I need.
Could you explain how to create the button and write the macro

Regards


"Gord Dibben" wrote:

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