VBA Toolbar is grayed out in Excel 2011 Mac Become a Registered Member (free) to remove the ad that appears in the top post. Click here to reset your password. Jul 13, 2012 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.
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.
Greyed out Tools, References option in VBA. Microsoft Access / VBA Forums on Bytes. 423,664 Members| 1,176 Online. Home > topics > microsoft access / vba > questions > greyed out tools, references option in vba. References option was greyed out and as I have never seen this happen before, after trying various things, searching here for.
Excel Vba On Mac
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.
Enable Vba Editor In Excel
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.