Nov 27, 2025 · MrExcel is your one stop for Excel tips and solutions. MrExcel offers help for excel including seminars and other training.

Jun 14, 2006 · 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. Is there a trick or a security setting within the …

May 24, 2006 · In Excel 2003 I'm trying to create a Userform but I can't seem to get the toolbox to display. I've been toggling the toolbox icon when I have the userform active but am having no luck. I …

May 29, 2025 · Microsoft Excel Tutorial: Excel Pivot Table Tools & Fields Pane Disappeared? Ever wondered why the Pivot Table Fields Pane suddenly vanishes in Excel? In this video, I dive into a bit …

Mar 3, 2025 · Even though the Excel team does not think many features are Home-tab-worthy, you can add your favorite features to the Quick Access Toolbar (QAT).

Mar 2, 2025 · Microsoft Excel Tutorial: Excel Clean Data with Copilot Microsoft Excel just introduced the Clean Data feature in Win32, bringing AI-powered data cleaning straight to the desktop! This tool, …

Jul 22, 2025 · Discover how to build a custom agent in Copilot for Excel that can search across all 2,500+ MrExcel YouTube videos using a massive dataset of transcripts, titles, and descriptions. In …

Jul 3, 2015 · Hi All, I have an issue currently with the toolbox for user forms. When I add a new userform in the vba editor and then select the toolbox so I can add some controls, the toolbox appears, …

Oct 18, 2006 · I am setting up VBA code to create different excel workbooks. One of the differences is in the VBA Tools References that must be enabled to make the whole thing function. How do I write …

Dec 4, 2011 · I also can't access any of the sheet specific vba code (they should all be empty, but I can't check). I found various 'solutions' around The Web telling me to go to Tools > References and check …