View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Rob Rob is offline
external usenet poster
 
Posts: 718
Default Open Find Dialog at WorkbookOpen

It Works!

Thanks Much!
R

"Bob Umlas" wrote:

How about:
Sub Answer()
SendKeys "^f%h{down}~"
End Sub

"Rob" wrote in message
...
I was wondering how I would make it to where everytime I open a specific
workbook the Find box automatically starts with the parameter to search
the
entire workbook?

I tried to use the SendKeys function but man that was messed up. I tried
to
record a macro and tweak it but that never worked.

Thanks In Advance,
R