Excel 2010 Find / Replace Dialog box loses focus
-
Wednesday, April 25, 2012 9:11 AMSince my team started using Using the Find dialog (CTRL + F) or Find and Replace (CTRL + H) tool in Excel 2010 Professional everyone has experienced problems with the dialog box immediately losing focus and text cannot be entered into the "Find what:" or replace boxes at all. Even clicking on the dialog does not remedy the problem. Infact the only way we have been able to use this function is to extremely quickly copy/paste text into each box when the dialog pops up. As you can imagine this has rendered an extremely useful function completely useless and dealing with data has become quite frustrating.
All Replies
-
Thursday, April 26, 2012 7:36 AMModerator
Hi,
It seems to be caused by the VBA code, please determine if some codes were written with Worksheet_SelectionChange event in the workbook. I would suggest disable and debug it.
Sincerely
Rex ZhangRex Zhang
TechNet Community Support
- Marked As Answer by Rex ZhangModerator Thursday, May 03, 2012 3:24 AM
- Unmarked As Answer by m0nonoke Thursday, May 03, 2012 10:01 AM
-
Thursday, May 03, 2012 10:03 AMUnfortunately this is not the answer. I do have some macros however none which touch the Worksheet_SelectionChange event. Also the behavior is exhibited on fresh workbooks with no macros at all. The same workbooks/macros etc to not have this problem when using Excel 2007.
-
Friday, May 04, 2012 1:40 AMModerator
Hi,
Have you tried starting Excel in safe mode?
If the issue cannot be reproduced by this, it might be related to the add-ins enabled in Excel 2010.
Best regards,
Rex Zhang
TechNet Community Support
.png)
