W wendi2309 Oct 14, 2003 #1 Is there a way, I can make Excel default the "look in" to 'values' when I open the Find dialog box, rather than formulas ??
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 Oct 14, 2003 #2 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
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
