Make Toolbar Icons Keyboard Shortcuts

[kollizion]

Ok, i do a TON of merging cells. Is there anyway to make it a keyboard shortcut? Is there anyway to make ANY toolbar icon a keyboard shortcut???

This would save me prolly 985449875894 hours. THANKS!

[tonywig]

Simply record a merge as a macro, giving the macro (as you record it) a shortcut key.

If you edit the macro (Tools, Macro) and remove any select statement recorded you will then have a macro that, when you press CTRL and your chosen key, will run. The macro should look something like ...

With Selection
.HorizontalAlignment = xlGeneral
.VerticalAlignment = xlBottom
.WrapText = False
.Orientation = 0
.ShrinkToFit = False
.MergeCells = True
End With

Tony.