Find and Replace
 

Hi

Is it possible to retain the options within the Find and Replace
dialogue box?

For example, I wish to always look within 'values' in the 'look in'
setting.
Whenever I open up the Spreadsheet aftering saving the file I find
that it automatically reverts to the devault 'look in formulas'
setting.

Excel 2000

Many thanks

Mark

Find and Replace
 

I don't think there is any way to make Excel retain that preference in the
Find dialog. The only solution I know of is to use a macro to open the Find
dialog. That way you can preset options:

Sub PresetFind()
Application.Dialogs(xlDialogFormulaFind).Show arg2:=2
End Sub


--
Jim Rech
Excel MVP