'Add toolbar to sheet
I'm trying to add a toolbar control on a sheet.
It does add the toolbar, but that error is not skippable with On Error Resume Next
, so it stops code from running.
Sub toolbar_Sheets_Add(wsTarget As Worksheet, sName As String, rWhereToCreate As Range)
Dim T As OLEObject
'On Error Resume Next
Set T = wsTarget.OLEObjects.add(ClassType:="MSComctlLib.Toolbar.2", Left:=rWhereToCreate.Left, Top:=rWhereToCreate.Top)
'T.Verb Verb:=xlOpen
On Error GoTo 0
T.name = sName
End Sub
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
Solution | Source |
---|