find default "look in"

W

wendi2309

Is there a way, I can make Excel default the "look in" to 'values' when
I open the Find dialog box, rather than formulas

??
 
D

Dave Peterson

It looks like excel tries to help by remembering the last thing you used.

So maybe you could have a dummy workbook that you put in your XLStart folder
that does a Find with the settings you like:

Option Explicit
Sub auto_open()

Worksheets("sheet1").Cells.Find What:="", After:=ActiveCell, _
LookIn:=xlValues, _
LookAt:=xlPart, SearchOrder:=xlByRows, _
SearchDirection:=xlNext, MatchCase:=False

ThisWorkbook.Close savechanges:=False

End Sub

The workbook opens, does a find (to fix your settings) and then closes to get
out of the way.

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top