Got a tip for us?
Let us know
Become a MacRumors Supporter for $50/year with no ads, ability to filter front page stories, and private forums.
How stop Visual Basic macros error message at opening Excel?
- Thread starter seleneS
- Start date
- Sort by reaction score
Which version of Excel are you running? If it's 2004 that message is probably due to it not support VBA. No idea if it can be turned off but upgrading to the current version that does support VBA would probably get rid of it...
The OP's posted screenshot is clearly from Excel 2011. Also, Excel 2004 most definitely supports VBA.
The Solution
Found the answer on Microsoft Forums.
1. Close Excel.
2. Go to Applications/Microsoft Office 2011/Office/Startup/Excel.
3. If there are any files in the Excel folder, delete them.
Problem solved for me.
Found the answer on Microsoft Forums.
1. Close Excel.
2. Go to Applications/Microsoft Office 2011/Office/Startup/Excel.
3. If there are any files in the Excel folder, delete them.
Problem solved for me.
VBA installation option
I had this issue and found that the VBA Macro option hadn't been installed when Office was first set up. Run the Office setup again and choose the 'Customize' option (about 3rd dialogue window into the routine). Scroll down and look for the VBA option and select it (it should say install), make sure everything else is unticked (skipped). I think you'll find it works after that.
I had this issue and found that the VBA Macro option hadn't been installed when Office was first set up. Run the Office setup again and choose the 'Customize' option (about 3rd dialogue window into the routine). Scroll down and look for the VBA option and select it (it should say install), make sure everything else is unticked (skipped). I think you'll find it works after that.
[doublepost=1458501407][/doublepost]Thank you for the tip. I had a little different problem, but this solved it. I have Office 365 with Office 2106 for MAC installed. I have been trying to run an app add-in for Excel called PhStat2. Found out is is not supported in Excel for Office 2016, so I installed just Excel 2011 via a custom install.This did not correct the issue I was having and I found your tip. When I installed Excel 2011 I did not install the VBA Option. I went back and did the custom install and select the VBA option and now my PHStat2 application is working.VBA installation option
I had this issue and found that the VBA Macro option hadn't been installed when Office was first set up. Run the Office setup again and choose the 'Customize' option (about 3rd dialogue window into the routine). Scroll down and look for the VBA option and select it (it should say install), make sure everything else is unticked (skipped). I think you'll find it works after that.