Changing The Find Dialog Box Default "Look In" Setting

[markkramer]

The Find dialog box defaults to Look In "Values" in every one of my workbooks except for one. For some reason, in this one workbook, the default setting is to Look In "Formulas". Since I never need to look in formulas when searching in this workbook, it's very annoying.

Do you know how to change the Find dialog box to default to Look In "Values" like it's set in all my other workbooks?

Thanks!

M