tool bar v2

2011/01/25

http://code.google.com/p/cowares-excel-hello/wiki/tool_bar_v2
add a cusomized toolbar to your VBA macro
ツールバー付きの VBA マクロを簡単に作る

Snapshots

button definitions and the generated tool bar

cowares said...: we released a small patch for excel tool bar. this patch will help you to isolate a namespace. meant for addin development.

Public Property Get ButtonParent() As Variant
- ButtonParent = Array(Me.CodeName)
+ ButtonParent = Array(ThisWorkbook.VBProject.Name & "." & Me.CodeName)
End Property; April 5, 2011 at 10:43 AM
cowares said...: we patch again.
trust to access the project name requires explicit setting, so avoid using VBProject.Name.

+Friend Function VBProjectName() As String
+ ' VBProject.Name can't be accessed for the default settings.
+ VBProjectName = "VBAProject"
+End Function

Public Property Get ButtonParent() As Variant
- ButtonParent = Array(ThisWorkbook.VBProject.Name & "." & Me.CodeName)
+ ButtonParent = Array(VBProjectName & "." & Me.CodeName)
End Property; April 6, 2011 at 10:59 PM