

If I'm wrong with all this I will be happy to learn otherwise :)īut as I said, this is just my point of view and maybe someone more experienced might help you out with a solution. Buy Excel 2016 VBA and Macros (includes Content Update Program) (MrExcel Library) 1 by Jelen, Bill (ISBN: 9780789755858) from Amazons Book Store. So this might provide a huge resource for errors. Is there any way to check if the user has VBA macros disabled in Excel, and then enable the.
EXCEL 2016 VBA AND MACROS 16 FOR MAC
I have been working on office for Mac 2011 for about 4 months with vba and it has been really hard to create some codes which on windows would have worked easily.Īlso would I not recommend doing what you want as functions which may have worked on 2011 may not work on 2016 as they have changed/deletet/recreated functions when changing the Office-Versions before. Bill Jelen, Excel MVP and the host of, has been using spreadsheets since 1985, and he launched the website in 1998.Bill was a regular guest on Call for Help with Leo Laporte and has produced more than 1,900 episodes of his daily video podcast, Learn Excel from MrExcel.
EXCEL 2016 VBA AND MACROS 16 MAC OS
Also a lot of code that works on office for windows is not working on Mac as the functionality of the Mac OS and the Windows OS are completely different.

On Mac this is even a bigger issue as they have added and reduced the functionalities over and over again. I don't think this is possible especially because with every change of version (from 2000 to 2003 to 2010 to 2013) there have always been changes in the vba coding.
