The first option on the View menu of the Office 2011 for Mac Visual Basic Editor (VBE) is the Code option, which is grayed out until you make at least one Code window visible in the VBE. A common way to open a new code window is to use Insert→Module. Jun 06, 2013 Re: Greyed out buttons in Excel 2011's Visual Basic Editor on Mac Thanks for your reply. I came across this page which might explain why the Visual Basic Editor is disabled. To correct this problem,first save the VBA customization and then shut down the VBA editor. Restart the VBA editor and go to Tools| References. This will refresh the VBA editor program and should provide access to references. May 11, 2017 Has there been any solution to the missing VBA in Excel 2016? I've been having the exact same issue with the same errors as OP. I am able to use VB and Macros in other Office applications such as Word, but am still unable to get it working in Excel. Tools -> References always grayed out I'm trying to setup a reference. And under the VBA editor Tools -> References is always grayed out no matter which sheet/class I have focused. For example, you can’t use Excel’s RAND function (which generates a random number) because VBA has an equivalent function: Rnd. VBA makes Excel’s worksheet functions available through the WorksheetFunction object, which is contained in the Application object. The first option on the View menu of the Office 2011 for Mac Visual Basic Editor (VBE) is the Code option, which is grayed out until you make at least one Code window visible in the VBE. A common way to open a new code window is to use Insert→Module.
I need help with a tool I have created for my office team to monitor their effort utilization using Excel 2013 VBA Macro.Unfortunately, the Macro could not find Add-Ins in anyone else's system than mine.In other's system, the 'References' button in VBA editor is grayed out.In order to make that work, they first need to restart the Editor and then try the Macro.However, I am looking for the Macro to work seemlessly without having users to go to VBA editor.Please help me with the solution.
2 Answers
One more caveat to it. You must make sure you press the stop button before you go to tools and references.
If the macro keeps running or if the error is highlighted, the references part will still be grayed out and none of the measures described above would work.
After a long research, I found some basic solutions that works fine on systems.If the VBA editor is showing the grayed 'References' or 'Additional Controls' buttons then there are two possible reason.
1st of them is answered in below link - https://support.microsoft.com/en-us/help/856804/vba-editor-references-option-is-grayed-out
2nd reason is related to the 'Administrative Access'.To solve the issue, try to run 'Excel' as administrator once, then select the respective 'Active X Controls' and 'References' that are required to run the Macro.
Once this is done, then the user will never face the problem again.
Not the answer you're looking for? Browse other questions tagged excelexcel-2013 or ask your own question.
Hyperlink Greyed Out In Excel
I just got a file from my colleague which has some broken links. They were broken because the path to the cells pointed directly to a file on her computer. She sent over those files, and now I have to repair the links. However, Excel won't let me choose to change source to those new files. It will let me choose to replace the source with some other Excel files, but the ones I want are greyed out. How do I make it so Excel will let me use those files as source?
2 Answers
I had this same problem with files that were being shared via Google Drive. The solution that worked for me was:
- Open the destination file - i.e. the one that is being linked to.
- If that in turn links anywhere choose
Ignore Links - Save the destination file
- Close the destination file
- Re-open the master file - i.e. the one you are linking out from.
- Choose
Edit Links - The previously greyed out files should now be no longer greyed out.
Have tried this with Excel 2008 and Excel 2011. 2011 was on Yosemite.
It might be that the files don't have a proper extension? Besides, you can manually edit the formula, and type in the full path to the desired files. Ideally, you should use a relative-path form: see, for instance the answer here.