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