Mynda Treacy
Admin
Forum Posts: 4703
Member Since:
July 16, 2010
July 16, 2010
Offline
Hi Bert,
I don't think there's a command that exists for that, but you could record your own Macro and then assign it to an icon in your QAT.
Mynda
Col Delane
Guest
Guests
Bert
Further to Mynda's post, here is the code that I use for a button on my QAT to do what you're after (plus wrap text within the cell):
Sub WrapAcross() On Error GoTo NoStyle ' If Wrap Across is not available as a style Selection.Style = "WrapAcrossSelection" 'Modify this style to change the formatting selections Exit Sub NoStyle: ' If Wrap Across style is not available With Selection .HorizontalAlignment = xlCenterAcrossSelection .VerticalAlignment = xlCenter .WrapText = True .Orientation = 0 .ShrinkToFit = False .MergeCells = False End With End Sub
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online: Shraddha Sureka
Guest(s) 7
Currently Browsing this Page:
1 Guest(s)
1 Guest(s)
Top Posters:
Catalin Bombea: 1917
SunnyKow: 1432
Anders Sehlstedt: 900
Purfleet: 414
Frans Visser: 346
David_Ng: 306
Hans Hallebeek: 287
lea cohen: 246
Jessica Stewart: 219
A.Maurizio: 216
Newest Members:
Ed Norris
manoj Ka
Chris Cowan
Pawel Ganczarski
Molly King
Faraz Rafi
Anthony Blake
Jackb57
Ben Tooke
Kelsey Fennell
Forum Stats:
Groups: 3
Forums: 24
Topics: 6873
Posts: 30124
Member Stats:
Guest Posters: 49
Members: 33675
Moderators: 2
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Jessica
Moderators: Velouria, Riny van Eekelen
© Simple:Press —