+ Reply to Thread
Results 1 to 3 of 3

VBA on Office 2016 for Mac

  1. #1
    Registered User
    Join Date
    04-08-2015
    Location
    Belgium
    MS-Off Ver
    Office 2013
    Posts
    51

    VBA on Office 2016 for Mac

    Hi,

    I recently purchased a new iMac (late 2015 27") and installed Office 2016 to be able to work on my VBA scripts from Excel (windows). Numbers just won't cut it I think :-).
    But the problem is, I can't even click the buttons in the dashboard, which need to open different userforms.

    Is Office 2016 for Mac compatible with Excel worksheets created in windows. Ae there any other problems with the mac version?

  2. #2
    Forum Guru Izandol's Avatar
    Join Date
    03-29-2012
    Location
    *
    MS-Off Ver
    Excel 20(03|10|13)
    Posts
    2,581

    Re: VBA on Office 2016 for Mac

    You may not use ActiveX controls on Mac - did you use Form buttons or ActiveX?

    There are many other problems with Mac VBA I fear.
    • Please remember to mark threads Solved with Thread Tools link at top of page.
    • Please use code tags when posting code: [code]Place your code here[/code]
    • Please read Forum Rules

  3. #3
    Registered User
    Join Date
    04-08-2015
    Location
    Belgium
    MS-Off Ver
    Office 2013
    Posts
    51

    Re: VBA on Office 2016 for Mac

    Ok thanks for this, I use bootcamp +W10 now to run a regular office version for my VBA projects.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. automate power query update from new tab (office excel 2016)
    By ajnuna in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-18-2016, 07:27 AM
  2. [SOLVED] Office 2016 cell comments on hover not working
    By leaning in forum Excel General
    Replies: 1
    Last Post: 01-10-2016, 11:20 PM
  3. Update from Office 97 to Office Professional Plus 2016
    By billd73 in forum Excel General
    Replies: 0
    Last Post: 12-28-2015, 05:15 PM
  4. Default excel template in Office 2016?
    By honeybadger_rgr in forum Excel General
    Replies: 0
    Last Post: 12-10-2015, 12:19 PM
  5. [SOLVED] Implement office 2016 version
    By YasserKhalil in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-02-2015, 01:32 PM
  6. VBA error 3706 connecting SQL Azsure Office 2016
    By LotusElise in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-28-2015, 10:46 AM
  7. Office 2016 Is it worth Upgrading?
    By TwistedFaith in forum Excel General
    Replies: 0
    Last Post: 08-25-2015, 06:10 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1