Office Mac 2011 - Excel Command Buttons

[ddnron]

I have command buttons that work fine in windows environment. I load Office mac 2011, and it opens workbooks fine, and I enable macros. I cannot get any of the command buttons to activate. It always gives me the design mode selection, where i can cut the button. I do not get the hand to activate the code when I select the button. Any idea how to activate the command buttons.

Thanks in advance for your help.

 

[Jim Gordon]

@ Rory - I've never seen a shred of documentation to support the idea about Apple not supporting Active-X due to security issues. Active-X is open source and anyone who wants to can port it to the Mac. So far no one has taken the time or made the effort, which is why Active-X is Windows only.

 

[Jim Gordon]

If your userform does not contain Active-X controls, you can use the File > Export option in Excel for Windows to save your form as a file, then use File > Import in Excel on the Mac to bring your form into Excel 2011. Likewise with your code modules.

 

[RoryA]

@ Rory - I've never seen a shred of documentation to support the idea about Apple not supporting Active-X due to security issues. Active-X is open source and anyone who wants to can port it to the Mac. So far no one has taken the time or made the effort, which is why Active-X is Windows only.

Not have I, but someone who used to work for them told me that.

 

[Jim Gordon]

Not have I, but someone who used to work for them told me that.

Well this is the closest I've ever come to hearing that someone from Apple actually said that. Just the same, I can't think of reason why Apple would have any interest in porting Active-X to the Mac except to make it easier for some Windows developers to make their apps cross-platform. It doesn't strike me as a very big market segment. Microsoft set Active-X free over a decade ago and little seems to have been done with it since. It hasn't gone away, but Active-X hasn't exactly taken off, either. The only way I see Active-X being ported to the Mac is if some developer really gets behind it and can make money off it somehow.