Open Find Dialog at WorkbookOpen

[Guest]

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

 

[Bob Umlas]

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

 

[Guest]

It Works!

Thanks Much!
R

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

 

[Steve]

--
Steve

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



To Bob Ulmus

What can I add to your following code to have it search only on Column A and >make it read only ? Sub Answer()
SendKeys "^f%h{down}~"
End Sub

Thanks