View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Don Guillett[_4_] Don Guillett[_4_] is offline
external usenet poster
 
Posts: 2,337
Default Can't get Find Box

try
Sub bringupfindbox()
Application.Dialogs(xlDialogFormulaFind).Show
End Sub

--
Don Guillett
SalesAid Software

"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