Excel 2013 - Disabling All Done box on find and replace

Factual Questions
1

Okay, not a big fan of Office 2013, I had to be dragged kicking and screaming from the 2000 version, but there it is.

Anyway, does anybody out there know of a way to disable the “All Done. We made xx replacements” popup after a find and replace?

An add-in would even be good.

I use Excel a lot for programming, and spend more time clearing the popup box then doing actual work.

Thanks

2

You can code your own replace macro:

And give it a hotkey.

Or you can use something like Autohotkey on a timer to watch for that dialog opening, and closing it automatically once it does.

Or really, just push the space bar to close that dialog when it appears… takes half a second

3

Rolling my own find and replace is just as much of a job as the one I’m trying to do for real.

Autohotkey is not an option, as it picks up other dialogs.

Just closing the dialog sounds great, but it isn’t. If that were a decent solution, I wouldn’t be asking.

4

It takes five minutes to code. Here’s a sample project with the macro written. The code is simply:



Private Sub CommandButton1_Click()

For Each sht In ActiveWorkbook.Worksheets
  sht.Cells.Replace what:=TextBox1.Text, Replacement:=TextBox2.Text, _
    LookAt:=xlPart, SearchOrder:=xlByRows, MatchCase:=False, _
    SearchFormat:=False, ReplaceFormat:=False
Next sht
UserForm1.Hide

End Sub

Autohotkey can filter by window title and text. Like this:



#SingleInstance
#Persistent

loop:
WinWaitActive, Microsoft Excel, All done
{
	WinClose
}
Goto, loop

Or if you don’t have Authotkey, here’s thesame script compiled into an exe.

5

As you can probably tell there’s no easy solution.

It’s probably just better to train yourself to close the window with [Enter], [Esc] (excel 2010) which can be done without removing your hands from the keyboard (assuming you’re already using Ctrl+H and Tab to open find/replace and navigate). Really, 5 minutes of training can create the muscle memory needed to optimize this action. (My personal mantra is unless you’re using charts, pivot tables, or other arcane controls there’s no reason to use the mouse in excel, it just slows you down)

Can you explain why this isn’t an option? It may open avenues to other solutions.:slight_smile: