New! GraphQL.NET Cookbook by Senthil Kumar Balu

How to disable the research task pane in Microsoft Excel?

In Microsoft Excel 2016 , when you press the Alt Key and simultaneously click a cell in the worksheet , a research pane would appear at the right hand side of the sheet. There are times when you would be noticing that it would be annoying and you might want to disable this functionality. Here’s how you do it.

image

How to disable the research task pane in Microsoft Excel 2016 using VBA Code?

1. Press Alt + F11 shortcut key to open the VBA Editor.

2. Press Ctrl + G to open the Immediate Window and enter the following code and press the enter key.

Application.CommandBars(“Research”).Enabled = False

3. Now , close the VBA Editor and check the excel worksheet to see the research task pane disabled.

Senthil Kumar B
Senthil Kumar is a former Microsoft MVP (Most Valuable Professional). He is a Co-Author of the book "Windows 10 Development Recipes using JavaScript and CSS" for Apress Publication. He is a technical presenter, blogger, mentor and a Geek.  Senthil is a regular speaker is various local user groups. He has presented at conferences like Great Indian Developer Summit (GIDS) & Microsoft DevCamps. You can reach out to him via his Twitter handle @isenthil.