Ah ha - that also explains why I didn't understand the objective !

Regards,
Peter T

"Dave Peterson" wrote in message
...
In xl2002+ (I think), there's an additional "within" setting under the
Options
button to look in the entire workbook.

That setting isn't exposed through VBA.

Peter T wrote:

Not sure I understand the objective but if it's to reset the options in
the
Find dialog to their default settings this macro should do it

Sub ResetFind()
Dim rng As Range

On Error Resume Next
Set rng = Cells.Find(What:="", _
LookIn:=xlFormulas, _
SearchOrder:=xlRows, _
LookAt:=xlPart, _
MatchCase:=False)

End Sub

Regards,
Peter T

"Dave Peterson" wrote in message
...
That setting can't be changed via "normal" excel code.

Maybe using Sendkeys????

Bob I wrote:

the setting "sticks" as long as Excel remains open, so perhaps run a
macro?

cpayneHTE wrote:

is there any way to default to the "workbook" setting instead of
"sheet" when
using the find function?

--

Dave Peterson

--

Dave Peterson