Find & Replace Options

[Alan Nordin]

Hello,

Is there a way to change the default options in the Find and Replace
window? Specifically I'd like to change the default value in "Look
In" from "formulas" to "values".

Thanks

 

[Don Guillett Excel MVP]

Hello,

Is there a way to change the default options in the Find and Replace
window?  Specifically I'd like to change the default value in "Look
In" from "formulas" to "values".

Thanks

You could place this macro in the ThisWorkbook module of the FIRST
workbook you open.

Private Sub Workbook_Open()
Set mf = Sheets(1).Cells.Find(What:="*", LookIn:=xlValues, _
LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:= _
xlNext, MatchCase:=False, SearchFormat:=False)
End Sub

 

[Alan Nordin]

You could place this macro in the ThisWorkbook module of the FIRST
workbook you open.

Sorry, didn't work, and now I get an annoying message when I close the
workbook and an annoying security info bar at the top when I open it.
I cut and paste the macro straight from your post, saved the macro,
saved, closed and reopened the workbook {the only workbook in use.}

 

[Alan Nordin]

{the only workbook in use.}

I should say "the only workbook open at anytime during the attempt".

 

[Don Guillett Excel MVP]

I should say "the only workbook open at anytime during the attempt".

Excel version______?
file extension______?
Security set to allow macros_________?
Placed in the ThisWorkbook module_____?
If all else fails, send me the file at dguillett@ gmail.com