Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I am using wrap text in excel, so why isn't all my text wrapping? | Excel Discussion (Misc queries) | |||
Just one cell in an Excel column won't text wrap. | New Users to Excel | |||
How do I set text to top of cell next to wrap text in Excel? | New Users to Excel | |||
Wrap text ceases to function in Excel if cell exceeds 9 lines | Excel Worksheet Functions | |||
Concatenation formula loses text wrap formatting | Excel Discussion (Misc queries) |