I am working with the example provided in:

http://msdn.microsoft.com/library/de...ce07042002.asp


I have created a custom button programmatically and assigned it a macro
using its OnAction property. I have checked the OnAction property to
ensure that it got set properly.

I tried setting this property to "MyTestSub", "Personal.xls!MyTestSub",
"Module1!MyTestSub", but none of them work. No error occurs when i
click the button; nothing happens at all. How do I get a VBE menuitem
to call a macro that I have in my Personal.xls? (Note: I also tried
this same thing in Word, and met with the same results).



Sub MyTestSub
MsgBox "Test"
End Sub