VBA missin in Excel for Mac 2016

[electrichi01]

Hello everyone

Updated to 2016 and it seems alot of the VBA functions are missing?

Is anyone else seeing this situation?

What is the solution, besides going back to 2011?

Any other options for some simple auto-calculations-----is there a way to calc sheets and do queries using formulas instead of VBA?

Thanks!

 

[RoryA]

The VB editor is basic compared to other versions at the moment, but vba functionality should be OK. What are you missing from 2011 specifically?

 

[electrichi01]

Hi Rory

Well, the buttons in my file don't work now to run the VBA.

Get the message when I open the file- that it isn't supported and wants to only open in read-only?

Its from the 2008 era and was a .xls which I changed to .xlsx

Suggestions?

 

[RoryA]

Your buttons don't work because they are ActiveX and that is not supported on the Mac. You'll have to change them to Form controls.

 

[electrichi01]

Rory

Thank you for your reply