davidhall80
Well-known Member
- Joined
- Jul 8, 2006
- Messages
- 663
This add in works, but I can't see the icon on my Menu Bar. The only way that I know its there is because when I hold my mouse over that area of my toolbar, the name of the Macro pops up. Are there any commands to add icons and words. I'd like to see a button image and the name of the Macro on the toolbar. Thanks in advance.
Code:
Private Sub Workbook_AddinInstall()
With Application.CommandBars("Standard").Controls.Add
.Caption = "&David"
.OnAction = "MRHALL"
End With
End Sub
Sub MRHALL()
Range("G23") = "David"
End Sub