Default setting in "Find" window

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

My "match entire cell content" box is checked on by default in the Find command when I open Excel. How can I set the default for this to be unchecked.
 
You sure it's checked by default. When I open xl2002, I don't have it checked.

But excel tries to be a good friend and remember everything you did your last
find (in the same excel session).
If you really want to change the setting (or any setting), you could have a
workbook whose only purpose in life is to do a dummy find--using your settings.

Start a new workbook.
Record a macro when you do a find (using the settings you like!)
Stop recording the macro.

I did it (and I changed a bunch of stuff--so don't just copy this!) and got this
back:

Option Explicit
Sub Macro1()

Cells.Find(What:="", After:=ActiveCell, LookIn:=xlComments, LookAt:= _
xlWhole, SearchOrder:=xlByColumns, SearchDirection:=xlNext, MatchCase:=
_
True, SearchFormat:=False).Activate
End Sub

Now modify it slightly:

Option Explicit
Sub auto_open()

With ThisWorkbook.Worksheets(1)

.Cells.Find What:="", After:=.Cells(1), LookIn:=xlComments, _
LookAt:=xlWhole, SearchOrder:=xlByColumns, _
SearchDirection:=xlNext, MatchCase:=True
End With

ThisWorkbook.Close savechanges:=False

End Sub

I named it auto_open (so it runs when the workbook opens).

I removed the Searchformat stuff (added in xl2002, so it may not work in your
version.)

And I added the last line that closes the workbook. (Save this workbook before
testing or you'll lose any changes!)

Now save this workbook in your XLStart folder--use windows start
button|find/search to look for it. Use any name you want "SetFindDefaults.xls"
looks pretty self documenting.

It opens, sets you up for the next find, and closes.

Again, don't use my code--I bet you don't want most of those settings!
 
Back
Top