Find & Replace Options

  • Thread starter Thread starter Alan Nordin
  • Start date Start date
A

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
 
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
Click to expand...
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
 
You could place this macro in the ThisWorkbook module of the FIRST
workbook you open.
Click to expand...

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.}
 
I should say "the only workbook open at anytime during the attempt".
Click to expand...

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
 
Back
Top