Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Sub CreateMenu()
- ' Delete the CommandBar if it exists already
- On Error Resume Next
- Application.CommandBars("Worksheet Menu Bar").Controls("My Tool").Delete
- Set cControl = Application.CommandBars("Worksheet Menu Bar").Controls.Add
- With cControl
- .Caption = "My Tool"
- .Style = msoButtonCaption
- End With
- End Sub
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement