Change default values for the Find function (2002

[pooja]

Is there anyway to change the default on Edit/Find to look for Values not formulas in specific workbook?

Thanks.
Pooja

[pooja]

I figured it out. Insert the code below. If you want to use it globally, insert it into your personal.xls. If you just want it on a specific workbook, insert it into a module.

Sub EditFind()
Application.Dialogs(xlDialogFormulaFind).Show , 2, , 2
End Sub

[pieterse]

Thanks for sharing your solution!