macros using find/replace
 

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.

macros using find/replace
 

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.