Text Wrapping Command
 

Please help, I am unsure if there is a command that can be added to the
toolbar but if there is one for text wrapping in a cell or a keyboard shorcut
could somebody please tell me, thank you.

you can make a quick macro such as
Sub wrp()
With Selection
.WrapText = True
End With
End Sub

then add a macro button to the toolbar and assign this macro to it or
<tools<macros<options and assign a keyboard shrortcut.



"Anthonyd" wrote:

Please help, I am unsure if there is a command that can be added to the
toolbar but if there is one for text wrapping in a cell or a keyboard shorcut
could somebody please tell me, thank you.

Or a toggle on/off macro.

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


Gord Dibben Excel MVP

On Mon, 9 May 2005 07:14:13 -0700, "bj" wrote:

you can make a quick macro such as
Sub wrp()
With Selection
.WrapText = True
End With
End Sub

then add a macro button to the toolbar and assign this macro to it or
<tools<macros<options and assign a keyboard shrortcut.



"Anthonyd" wrote:

Please help, I am unsure if there is a command that can be added to the
toolbar but if there is one for text wrapping in a cell or a keyboard shorcut
could somebody please tell me, thank you.

Thanks BJ.

"bj" wrote:

you can make a quick macro such as
Sub wrp()
With Selection
.WrapText = True
End With
End Sub

then add a macro button to the toolbar and assign this macro to it or
<tools<macros<options and assign a keyboard shrortcut.



"Anthonyd" wrote:

Please help, I am unsure if there is a command that can be added to the
toolbar but if there is one for text wrapping in a cell or a keyboard shorcut
could somebody please tell me, thank you.

Thank you Gord.

"Gord Dibben" wrote:

Or a toggle on/off macro.

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


Gord Dibben Excel MVP

On Mon, 9 May 2005 07:14:13 -0700, "bj" wrote:

you can make a quick macro such as
Sub wrp()
With Selection
.WrapText = True
End With
End Sub

then add a macro button to the toolbar and assign this macro to it or
<tools<macros<options and assign a keyboard shrortcut.



"Anthonyd" wrote:

Please help, I am unsure if there is a command that can be added to the
toolbar but if there is one for text wrapping in a cell or a keyboard shorcut
could somebody please tell me, thank you.