If you are authoring Macros for Office for Mac, you can use most of the same objects that are available in VBA for Office. For information about VBA for Excel, PowerPoint, and Word, see the following: Unlike other versions of Office apps that support VBA, Office 2016 for Mac apps are sandboxed. If you have performed a custom installation of Office, you may need to run the installer again, ensuring that 'Visual Basic for Applications' is selected.' I use Word 2016 with my enterprise Office 365 account on an El Capitan Mac, which I just upgraded to.
See solution in other versions of Excel:. You can access the VBA environment in Excel 2011 for Mac by opening the Visual Basic editor. First, be sure that the Developer tab is visible in the toolbar in Excel. The Developer tab is the toolbar that has the buttons to open the VBA editor and create Form Controls like buttons, checkboxes, etc. To display the Developer tab, click on Preferences under the Excel menu at the top of the screen.
When the Excel Preferences window appears, click on the Ribbon icon in the Sharing and Privacy section. In the Customize section, check Developer in the list of tabs to show. Then click on the OK button. Select the Developer tab from the toolbar at the top of the screen.
Then click on the Editor option in the Visual Basic group. Now the Microsoft Visual Basic editor should appear and you can view your VBA code.
I've just moved all my files from my old iMac to my new (well new to me - it's a second-hand 2010 2.4 GHz 13 inch model) MacBook Pro using Migration Assistant. Everything worked flawlessly apart from one thing - whenever I try and use a macro now in MS Office 2011 I get the following message:. Can't load Visual Basic for Applications Make sure Visual Basic for Applications is installed on your computer.
If Visual Basic for Applications is installed, make sure the path to the installation folder does not contain any characters outside of the system code page (such as Cyrillic characters on an English system) and contains fewer than 255 characters. Visual basic worked perfectly before on my old iMac, so I have no idea what has happened here to throw it out. VBA is installed, and the path is: 'MBP/Applications/Microsoft Office 2011/Office/Visual Basic for Applications.framework/Visual Basic for Applications' so no strange characters and well under 255 characters too. From the error message it seems all I have to do is tell Word where to look to find the program and it will be happy, but in typical Microsoft fashion the error tells me what's wrong but not where to go to fix it or how. There's nothing obvious in Word under PreferencesFile locations, and I've tried reinstalling just Visual Basic for Applications from the Office 2011 DVD but that didn't change anything either - same error message and the files are in the same place on my hard drive. I'm loathe to entirely reinstall office to fix what appears to be a relatively simple issue as I'll have to set it up from scratch again. Does anyone know where/what I have to do to point Word in the right direction?
Both the iMac and the MacBook are on Mountain Lion, and the transfer worked perfectly otherwise. I can't find anyone else having had this issue after an upgrade using Migration Assistant, so any help gratefully recieved! Just struggled through this one for a while. I updated Office, then replaced prefs in both /Documents/Microsoft User Data and /Library/Preferences/Microsoft. In the end, here's what worked:.
Locate com.microsoft.Word.plist in /Library/Preferences. Find an earlier version of this file in Time Machine (before the odd VB dialogs started appearing). If you don't have a clean backup, it would probably work to trash the file and start over, but I wanted to keep my preferences.
Possible fix for message: Can't load Visual Basic for Applications, Macbook Pro Retina, Running El Capitan, Mac Office 2011. Trawled through dozens of posts before I decided to have a look through the Microsoft Office 2011 Folder: Go to Applications: Open MS Office 2011 folder, Then open folder named, Office. This folder has a myriad of folders and information including subfolders called Add-ins, Help, Media, etc. Amongst these folders is one called 'Startup'. This folder appears to have nothing in it except a simple startup protocol that insists Word start by questioning the whereabouts of VB. Delete this folder to the trash.
Close Word then open it up and the message should go. Let me know how it works out. I used Migration Assistant to move from Yosemite on my 2011 MacBook Pro to my 2014 MacBook Pro, and this happened to me. I have EndNote X6 installed, and I was able to fix it without removing EndNote entirely.
Start EndNote X6 Open Customizer on the EndNote X6 menu UNCHECK the 'Cite While You Write' option (this is the option that installs the problematic code in Word). Click Next (rather than Uninstall) Click Next again (even though their window says that they'll be installing the feature, it actually removes it from Word. Now you can exit EndNote X6 (or not) and start Word (I have Word 2011), and it works fine.
No more VBA error that makes it unusable. Just struggled through this one for a while. I updated Office, then replaced prefs in both /Documents/Microsoft User Data and /Library/Preferences/Microsoft. In the end, here's what worked:. Locate com.microsoft.Word.plist in /Library/Preferences. Find an earlier version of this file in Time Machine (before the odd VB dialogs started appearing).
If you don't have a clean backup, it would probably work to trash the file and start over, but I wanted to keep my preferences. Mmm - just found this problem too. Migrated to new machine OK, (a 2010 Macpro Mtn Lion), but although Excel & Word seemed to work normally, Visual basic give me the 'Can't load Visual basic For Applications' error message. Tried a custom install for VBA only - and wheheee - it worked. Ran my macro, which then froze Excell and had to force quit Excel.
![Microsoft visual basic mac Microsoft visual basic mac](/uploads/1/2/4/2/124226191/471735257.gif)
![Visual basic for applications download Visual basic for applications download](/uploads/1/2/4/2/124226191/940730485.jpg)
Tried the VBA editor to look for any errors, but just received the error message again. Tried some of the suggestions above - trashing preferences etc - but no effect.
Saw another suggestion to change the name of the hard drive name back to its original name, and now it seems to work OK. You cant make this stuff up sometimes. I was having the same problem on my macbook air - for similar reasons (migrating from one mac to another). For a while it would work ok if I just clicked 'ok' on the screen with the error message (saw the screen twice, clicked ok twice each time!) that appeared when starting Word. Then - after a system upgrade I think - it crashed Word at startup and I had to force quit to get out.
Happily problem is now solved - upgraded to Endnote X6. However, you have to make sure you uninstall and then trash earlier versions of Endnote. Used Mavericks migration asstant to move to a new MacBook Pro 7 days ago and Word became unusable with Dragon Dictate for Mac with the ' Can't load Visual Basic for Applications' message. After talking to the nice people at Apple support, they suggested calling the Microsoft Mac team- who wanted £65 to talk to me. Decided, with Pages installed, that Word wasn't worth the money to me, so politely declined and went back to the forums and worked through the suggestions to delete the preferences, run the updates again, using Font book to repair fonts & co Tried the 'rename the HD to the same as the original' suggestion without sucess- The only thing that worked for me was to reinstall Office from the disk image.
Painless - and the reinstalation preserved my registration and templates. Only problem was locating my copy of the disk image!
I used Migration Assistant to move from Yosemite on my 2011 MacBook Pro to my 2014 MacBook Pro, and this happened to me. I have EndNote X6 installed, and I was able to fix it without removing EndNote entirely. Start EndNote X6 Open Customizer on the EndNote X6 menu UNCHECK the 'Cite While You Write' option (this is the option that installs the problematic code in Word). Click Next (rather than Uninstall) Click Next again (even though their window says that they'll be installing the feature, it actually removes it from Word. Now you can exit EndNote X6 (or not) and start Word (I have Word 2011), and it works fine. No more VBA error that makes it unusable.
Apple Footer. This site contains user submitted content, comments and opinions and is for informational purposes only. Apple may provide or recommend responses as a possible solution based on the information provided; every potential issue may involve several factors not detailed in the conversations captured in an electronic forum and Apple can therefore provide no guarantee as to the efficacy of any proposed solutions on the community forums. Apple disclaims any and all liability for the acts, omissions and conduct of any third parties in connection with or related to your use of the site. All postings and use of the content on this site are subject to the.