Why do you want the dialog box to be open at all - why not just prompt
for the details (with a custom userform I would suggest) and then get
the macro to do the find and replacing using these parameters?
TB wrote:
How do I record a macro to bring up the dialog box for find/replace and leave
open. Each time I record and stop the macro after the box is open, it does
not stay open. The replaced data will be different each week and requires
the user to update.