Research Pane

[Shay A]

Hi,
Is there a simple way to disable it? In Excel and in Office in general.

TY!

 

[ThrottleWorks]

Hi @Shay A , please check below links, might help. Please note, I have not personally tried this.

https://social.technet.microsoft.com/Forums/windows/en-US/3ba9d475-756f-48a8-a553-4a9eeed423b5/disable-windows-f1-hotkey?forum=w7itprogeneral

http://h30434.www3.hp.com/t5/Deskto...isable-Windows-8-F1-Key-Shortcut/td-p/2451121

 

[NARAYANK991]

Hi ,

See if this helps :

https://www.extendoffice.com/documents/excel/2324-excel-disable-research-task-pane.html

Narayan

 

[Shay A]

Yes but does it apply to all of the Excel workbooks or just the one where tje code is in?

 

[NARAYANK991]

Yes but does it apply to all of the Excel workbooks or just the one where tje code is in?

Hi ,

When we use :

Application........

we mean the Excel application ; this means that what ever change is made will affect the Excel application , not just one workbook.

This change is sticky , which means once it is done , you do not need to do it each time you open Excel ; it will remain in force till such time you undo it yourself.

Narayan

 

[Shay A]

Hi,
So basically all I need to do is to open workbook and to execute tp aforementioned code, to save this workbook and that's it?

TY

 

[NARAYANK991]

Hi,
So basically all I need to do is to open workbook and to execute the aforementioned code, to save this workbook and that's it?

TY

Hi ,

If you execute the code line once , it will apply forever to all workbooks ; only by executing the code line again ( with the False replaced by True ) will Excel revert to its earlier behaviour.

Narayan

 

[Shay A]

Thank you, I hope this issue is resolved. Now, this problem is bugging me on other Office's applications- Word, Outllok, Powerpoint, is the line of code similar like to that of Excel?

TY

 

[NARAYANK991]

Hi ,

Yes ; you can type in the same command in the Immediate window when these other applications are run. For instance , in Word , you would again go to the Visual Basic editor screen , and in the Immediate window , type in :

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

and it would work the same way.

Narayan

 

[Shay A]

Hi ,

Yes ; you can type in the same command in the Immediate window when these other applications are run. For instance , in Word , you would again go to the Visual Basic editor screen , and in the Immediate window , type in :

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

and it would work the same way.

Narayan

Hi,
I have ti say thay I pasted the command in the immediate window but after the pane kept popping up. After that, I ran the code as a sub procedure, saved the changes and closed the workbook. I hope this will do the work.

TY