Nov 04 2021 11:05 AM
Hello.
In Excel 365 is there a way to dock or keep open the cell styles pane like what used to be possible in prior versions of Excel? I have to believe there is some way to do this. Thanks!
Nov 05 2021 09:00 AM - edited Nov 05 2021 09:01 AM
If you don't mind a bit of VBA code, this code adds the styles drop-down to your add-ins tab:
Sub AddStylesBoxToAddInsTab()
Dim oCb As CommandBar
Dim cControl As CommandBarControl
On Error Resume Next
Application.CommandBars("Temp").Delete
Set oCb = Application.CommandBars("Temp")
Set oCb = Application.CommandBars.Add("Temp", , True, True)
Set cControl = oCb.Controls.Add(ID:=1732)
oCb.Visible = True
End Sub
The code needs to be run each time Excel starts.
May 23 2022 06:15 AM