Search Preferences Don't Save When Changed

  • Thread starter Thread starter Rosen
  • Start date Start date
R

Rosen

I've been experiencing some annoying behavior in Excel.
Everytime I open the search/replace dialog, the Options
panel is hidden and "Match entire cell contents" is
selected. I know it's not a default, but everytime I
uncheck it, Excel doesn't save that change for the next
time I run Excel.

What can I do so that whatever I change is set to default
the next time I run the app?
 
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
 
-----Original Message-----
Maybe you could have a dummy workbook that you put in your XLStart folder that
does a Find with the settings you like:
Click to expand...


Good suggestion, but I'd rather fix the root cause. Why
isn't it saving the last used setting anymore?
 
Back
Top