Open Find Dialog at WorkbookOpen
 

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

Open Find Dialog at WorkbookOpen
 

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

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

Open Find Dialog at WorkbookOpen
 

--
Steve


"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

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