On 2002-05-06 00:04, Phylis Sophical wrote:
Ricky how do you make or where do you get the 'Center across selection' button? That is so valuable. I'd love to NOT have to go through the Format Cells thing.
Create your own button and assign a macro.
You can record a macro (and put it in your Pesonal.xls), a tidied-up version of which :-
Sub Centre_Across_Selection()
Selection.HorizontalAlignment = xlCenterAcrossSelection
End Sub
You can create your own buttons and assigned macros for whatever you want.
For example, among the many I use :-
- Disable/enable event procedures
- Turn off move after entry
- Toggle formula cells between showing the result and showing the formula (good for copying formulas and pasting elsewhere)
- Convert formulas to values
- Copy non-contiguous selections
- Identify cells containing formulas
- Reset last cell
- Unhide next column (or next row)
- Wrap text
- Add a leading bullet
- Convert to lower/upper/proper case
- Capitalise first letter only
- Count of pages that will print
etc.
etc.