Is there a Wrap Text command button?
 

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

�lvaro

Is there a Wrap Text command button?
 

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

Is there a Wrap Text command button?
 

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

Is there a Wrap Text command button?
 

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

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

Is there a Wrap Text command button?
 

If not familiar with VBA and macros, see David McRitchie's site for more on
"getting started".

http://www.mvps.org/dmcritchie/excel/getstarted.htm

In the meantime..........

First...create a backup copy of your original workbook.

To create a General Module, hit ALT + F11 to open the Visual Basic Editor.

Hit CRTL + r to open Project Explorer.

Find your workbook/project and select it.

Right-click and InsertModule. Paste the code in there. Save the
workbook and hit ALT + Q to return to your workbook.

Run the macro by going to ToolMacroMacros.

To create a button you can use a button from the Forms Toolbar which will place
a button on your sheet.

Right-click and "assign macro".

If you want a button on an existing Toolbar................

ToolsCustomizeCommandsMacros.

Drag the Smiley Face up to an existing Toolbar and drop it there.

Right-click and "Assign macro".


Gord

On Fri, 1 Dec 2006 04:32:00 -0800, jmoder
wrote:

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



Gord Dibben MS Excel MVP