Saturday 25 April 2015

HOW TO DISABLE OR CLOSE RESEARCH TASK PANE IN MS EXCEL / RESEARCH TASK PANE IN MS EXCEL

HOW TO DISABLE OR CLOSE RESEARCH TASK PANE IN MS EXCEL / 

IF YOUR PROBLEM IS ANY OF THE BELOW: 

1) RESEARCH TASK PANE APPEARS IN MS EXCEL AND DOESN'T CLOSES EVEN AFTER CLOSING IT

2) RESEARCH TASK PANE AUTOMATICALLY APPEARS IN MS EXCEL AND NOT ALLOWING TO WORK

3) RESEARCH TASK PANE AUTOMATICALLY APPEARS IN MS EXCEL AND IT APPEARS WHEN YOU TRY TO CLICK OR WRITE ON ANY CELL

1) RESEARCH TASK PANE APPEARS IN MS WORD AND DOESN'T CLOSES EVEN AFTER CLOSING IT

2) RESEARCH TASK PANE AUTOMATICALLY APPEARS IN MS WORD AND NOT ALLOWING TO WORK

3) RESEARCH TASK PANE AUTOMATICALLY APPEARS IN MS WORD AND IT APPEARS WHEN YOU TRY TO CLICK OR WRITE SOMETHING


THEN THE SOLUTION IS:

STEP 1: 

PRESS ALT F11 FROM WORD OR EXCEL (IN WHICH YOU HAVE PROBLEM)

THIS WILL OPEN VB EDITOR I.E. VIRTUAL BASIC EDITOR PAGE

STEP 2: PRESS CTRL G

THIS WILL OPEN "IMMEDIATE WINDOW"

STEP 3: TYPE Application.CommandBars("Research").Enabled = False AND PRESS ENTER

OR JUST PASTE THE Application.CommandBars("Research").Enabled = False

IN THE IMMEDIATE WINDOW AND PRESS ENTER

STEP 4: CLOSE THE WINDOW AND NOW START WORKING.........


HOPE YOU WILL FIND THIS HELPFUL

MOHAMMED ISMAIL