macros not working on macintosh

[JTBorton]

Hey, i'm having trouble getting macros to work on excel for macintosh systems. I think, based on what I've read online, that it's because I created them using active x controls. Or something like that, what ever that means. Is there some kind of patch that can be downloaded so that the macros will work correctly on a mac?

On the highlighted code I get the following error
Compile Error:
Automation Error

Sub AddMenus()
[highlight]Dim cMenu1 As CommandBarControl[/highlight]
Dim cbMainMenuBar As CommandBar
Dim iHelpMenu As Integer
Dim cbcCutomMenu As CommandBarControl

Thanks!



-JTBorton
Another Day, Another Disaster

 

[GVF]

Check this link. The article is called "VBA for MacIntosh goes away"

http://www.joelonsoftware.com/items/2007/04/25.html

another one

http://www.macnn.com/articles/06/08/07/ms.kills.virtualpc/

Active X controls must be referenced in the VBA editor under "Tools > References". If you haven't added any references, then ActiveX shouldn't be an issue with your code.

That being said, try:
Dim cMenu1, cbcCustomMenu as CommandBarPopup 'for a drop down
or as CommandBarButton if you just need a menu item that runs a procedure.

GVF