How to Disable the Research Task Pane in Excel

This post will explain how to disable the research task pane in Excel 2010/2013/2016. How do I stop the research pane appearing in Microsoft Excel.

Disable/Stop Research Pane


When you press Alt key on your keyboard, and then click a cell simultaneously in your worksheet, a research task pane will appear at the right side of the current worksheet. It may be annoying for your and you may be want to disable or stop this functionality in your worksheet. How to achieve it. You can use a simple VBA Code to disable the research task pane in Microsoft worksheet. Just do the following steps:

#1 open your excel workbook and then click on “Visual Basic” command under DEVELOPER Tab, or just press “ALT+F11” shortcut.

Get the position of the nth using excel vba1

#2 then the “Visual Basic Editor” window will appear.

#3 click View menu, and select Immediate Window from the drop down menu list. And the Immediate window will be shown in the VBA Editor.  Or you can press Ctrl + G shortcut to open the immediate window directly.

disable reserach task pane1

#4 enter the following code in the Immediate Window, and press Enter key.

disable reserach task pane2

Application.CommandBars("Research").Enabled = False

#5 close the VBA Editor and try to check if the research task pane has been disabled via press Alt + Click in your worksheet.

 

 

 

 

You might also like:

Comments

So empty here ... leave a comment!

Leave a Reply

Your email address will not be published. Required fields are marked *

Sidebar