# Excel 2013 - Disabling All Done box on find and replace

**URL:** <https://boards.straightdope.com/t/excel-2013-disabling-all-done-box-on-find-and-replace/714825>\
**Category:** Factual Questions\
**Created:** [March 12, 2015, 1:28pm UTC](https://boards.straightdope.com/t/excel-2013-disabling-all-done-box-on-find-and-replace/714825 "2015-03-12T13:28:56Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Khendrask](https://avatars.discourse-cdn.com/v4/letter/k/3e96dc/32.png) [@Khendrask](https://boards.straightdope.com/u/Khendrask)\
**Post date:** [March 12, 2015, 1:28pm UTC](https://boards.straightdope.com/t/excel-2013-disabling-all-done-box-on-find-and-replace/714825/1 "2015-03-12T13:28:56Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![Reply](https://sea3.discourse-cdn.com/straightdope/user_avatar/boards.straightdope.com/reply/32/15952_2.png) [@Reply](https://boards.straightdope.com/u/Reply)\
**Post date:** [March 12, 2015, 2:45pm UTC](https://boards.straightdope.com/t/excel-2013-disabling-all-done-box-on-find-and-replace/714825/2 "2015-03-12T14:45:43Z")

</div>

You can code your own replace macro:

> **[MS Excel: How to use the REPLACE Function (VBA)](https://www.techonthenet.com/excel/formulas/replace_vba.php)**
>
> This Excel tutorial explains how to use the Excel REPLACE function (in VBA) with syntax and examples. The Microsoft Excel REPLACE function replaces a sequence of characters in a string with another set of characters.

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

---

<div class="post-metadata">

**Author:** ![Khendrask](https://avatars.discourse-cdn.com/v4/letter/k/3e96dc/32.png) [@Khendrask](https://boards.straightdope.com/u/Khendrask)\
**Post date:** [March 12, 2015, 5:06pm UTC](https://boards.straightdope.com/t/excel-2013-disabling-all-done-box-on-find-and-replace/714825/3 "2015-03-12T17:06:04Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![Reply](https://sea3.discourse-cdn.com/straightdope/user_avatar/boards.straightdope.com/reply/32/15952_2.png) [@Reply](https://boards.straightdope.com/u/Reply)\
**Post date:** [March 13, 2015, 1:11am UTC](https://boards.straightdope.com/t/excel-2013-disabling-all-done-box-on-find-and-replace/714825/4 "2015-03-13T01:11:17Z")

</div>

> [@Khendrask](#):
>
> Rolling my own find and replace is just as much of a job as the one I’m trying to do for real.

It takes five minutes to code. Here’s [a sample project with the macro written](https://www.dropbox.com/s/swkgi87v6thwsut/findandreplace.xlsm?dl=0). The code is simply:

```auto

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 is not an option, as it picks up other dialogs.

Autohotkey can filter by window title and text. Like [this](https://www.dropbox.com/s/1l3nqtkklwrzi60/auto-close-excel-replace.ahk?dl=0):

```auto

#SingleInstance
#Persistent

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

```

Or if you don’t have Authotkey, here’s the[same script compiled into an exe](https://www.dropbox.com/s/oi6p7ch1dt2826k/auto-close-excel-replace.exe?dl=0).

---

<div class="post-metadata">

**Author:** ![FasterThanMeerkats](https://avatars.discourse-cdn.com/v4/letter/f/278dde/32.png) [@FasterThanMeerkats](https://boards.straightdope.com/u/FasterThanMeerkats)\
**Post date:** [March 13, 2015, 4:01pm UTC](https://boards.straightdope.com/t/excel-2013-disabling-all-done-box-on-find-and-replace/714825/5 "2015-03-13T16:01:05Z")

</div>

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.🙂