VBE Custom menuitem not calling OnAction macro

R

R Avery

I am working with the example provided in:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnofftalk/html/office07042002.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
 
B

Bob Flanagan

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Deleting custom menu item createt in VBA 1
MenuItem Check Mark 1
error running macro from Ribbon button 1
Custom Images not showing in Ribbon toggle button 2
How to keep custom menu from being killed until all wkbk copys clo 5
Button image not loading on Custom Ribbon 1
Calling macro from a different addin 2
passing parameters to function assigned to button property onAction?? 0

Top