Hi E,

Try:

Application.Dialogs(xlDialogFormulaFind).Show


---
Regards,
Norman



"EMoe" wrote in message
...

Hello Programmers.

How can we through Macro, prompt the Find box to come up when an excel
spreadsheet is first opened. I tried to record this action by usinf
CTRL+F, and find selecting Edit, then Find, but it doesn't show up in
the code.

Is there way to write this into a code?

Thanks,
EMoe


--
EMoe
------------------------------------------------------------------------
EMoe's Profile:
http://www.excelforum.com/member.php...o&userid=23183
View this thread: http://www.excelforum.com/showthread...hreadid=483123