It sounds like you have macro protection set to high, and have opened the
workbook since you put a macro in it. Microsoft does not warn you that
macros are disabled when protection is set to high, nor tell you that macros
you try to run are disabled.

Try setting protection to medium and closing and re-opening the workbook.

Bob Flanagan
Macro Systems
Delaware, U.S. 302-234-9857
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel

"R Avery" wrote in message
...
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