Office 365 and VBA on Mac

  • Sorry if this has been asked before, I even called Microsoft Sales and they didn't have an answer, which I found quite shocking.


    I'm currently on Office 2011 for Mac. I make extensive use of VBA daily. I'm looking to get a new M1 laptop when the 16-inch becomes available later this year. My son just got a 13-inch MBP today. I tried to install the old 2011, no luck since it's a 32-bit app.


    Big question is what current version supports VBA? I tried Office 2019 before. That had some issues with the sandboxing and limited file locations. As well as a big issue that you couldn't edit User Forms, just work with existing Forms. Maybe this has been fixed since the early release? I gave up on that and stuck with my old friend Office 2011.


    Does Office 365 support VBA?


    Suggestions for best options moving forward?


    Regards,


    Tim

  • Yes it does support VBA, but with the same issues you experienced before. There is still no userform editor (after 5 years!!) and the sandboxing is still a PITA (though that one is on Apple). I'd strongly recommend a VM if you need to use VBA on a Mac - Parallels now has an M1 compatible version out, for example.

    Rory
    Theory is when you know something, but it doesn’t work. Practice is when something works, but you don’t know why. Programmers combine theory and practice: nothing works and they don’t know why

  • Thanks for the insights. Is your suggestion to run an older Mac OS in Parallels to still run Office 2011? And that would only be necessary if I needed to edit a UserForm (rare, thankfully) and take advantage of a 64-bit version day-to-day?

  • I was actually suggesting running Windows in a VM so you can use the Windows version of Office/Excel rather than the slightly crippled Mac version.

    Rory
    Theory is when you know something, but it doesn’t work. Practice is when something works, but you don’t know why. Programmers combine theory and practice: nothing works and they don’t know why

  • Yes it does support VBA, but with the same issues you experienced before. There is still no userform editor (after 5 years!!) and the sandboxing is still a PITA (though that one is on Apple). I'd strongly recommend a VM if you need to use VBA on a Mac - Parallels now has an M1 compatible version out, for example.

    Thank you for this post. Good luck.