References in Excel 2013 VBA editor is grayed out

excel excel-2013
Anurag Thakur picture Anurag Thakur · Nov 7, 2017 · Viewed 12.5k times · Source

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.

Answer

Sumit Pokhrel picture Sumit Pokhrel · Mar 18, 2019

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.

Related questions

If two cells match, return value from third

Here's a simple explanation of what I'm having trouble with. Column A: List of 2300 order numbers Column B: Email Address associated with an order number Column C: List of 100 specific order numbers that I need the email address for So, …

Read More
Excel: Searching for multiple terms in a cell

I use this handy equation to search for a term inside of a cell in excel. =IF(ISNUMBER(SEARCH("*Gingrich*",C1)),"1","") This equation searches for the presence of Gingrich in C1, if it exists, it displays a 1. All I'd like …

Read More
Clear contents and formatting of an Excel cell with a single command

If you want to clear the contents of a cell or range in Microsoft Excel, you can use .ClearContents. If you also want to clear the formatting, you can use .ClearFormats. Sheets("Test").Range("A1:C3").ClearContents Sheets("Test").Range("…

Read More