Speed button to wrap text

S

Sanjay Shah

Is there any way to create a speed button to wrap / unwrap text in Excel
without having to go through - Format Cells, Alignment Tab, Wrat Text?

Thanks in advance for the help
 
G

Gord Dibben

Sanjay

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

Toggles on/off.

Copy/paste to a general module in your workbook or Personal.xls and assign it to
a button.


Gord Dibben MS Excel MVP
 
S

Sanjay Shah

Thank you very much Gord Dibben

I have tried this and it works exactly as you described it. This will save
me a lot of time.
 
Top