use the workbook's open event ...

Private Sub Workbook_Open()
Application.Dialogs(xlDialogFormulaFind).Show
End Sub

this is in the code behind ThisWorkbook. Are you ok finding that?

"jessdaisy" wrote:

Hi -

I am looking to open a file with the Find function enabled immediately. I
thought I could do this using an auto_open macro, however, the Find dialog
box doesn't appear.

Is there a way I can make the dialog box appear with the macro or is there a
different way to have the Find function open automatically upon opening a
file?

Thanks!
Jessica