How do I change the defaults on the Find dialog box? I want the defaults to
be search by columns and values.
--
Thank you... Elaine
How do I change the defaults on the Find dialog box? I want the defaults to
be search by columns and values.
--
Thank you... Elaine
Click the "options" button and all the extra search parameters will be displayed
HTH
Martin
Martin Short
Hello Martin,
The options button will keep the changes until you exit the program. How do
you keep the Search by "Columns", Look in "Values" as permanent defaults? I'm
using Excel 2000.
--
Thank you... Elaine
"MartinShort" wrote:
>
> Click the "options" button and all the extra search parameters will be
> displayed
>
> HTH
>
> Martin
>
>
> --
> MartinShort
>
> Software Tester
> ------------------------------------------------------------------------
> MartinShort's Profile: http://www.excelforum.com/member.php...o&userid=22034
> View this thread: http://www.excelforum.com/showthread...hreadid=553793
>
>
A lot more difficult I'm afraid as Excel's standard user interface isn't that customisable.
It would be possible to record/write a macro to do what you want and set up a button on your toolbar to access it. You might need to tweak it though with a custom form listing the inputs you want, but yes it can be done.
Are you able to record macros?
Martin
Saved from a previous post:
Excel tries to help by remembering the last settings you used--except for the
first search in that session.
You can use that to your advantage.
You could make a dummy workbook and put it in your xlStart folder. Have a
macro in that workbook that does a find (and sets all the stuff the way you
like). Then closes and gets out of the way.
Option Explicit
Sub auto_open()
Worksheets("sheet1").Cells.Find What:="", After:=ActiveCell, _
LookIn:=xlValues, _
LookAt:=xlPart, SearchOrder:=xlByColumns, _
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
But if you do an Edit|Find and change anything, then those changed settings will
be remembered.
Elaine wrote:
>
> Hello Martin,
>
> The options button will keep the changes until you exit the program. How do
> you keep the Search by "Columns", Look in "Values" as permanent defaults? I'm
> using Excel 2000.
> --
> Thank you... Elaine
>
> "MartinShort" wrote:
>
> >
> > Click the "options" button and all the extra search parameters will be
> > displayed
> >
> > HTH
> >
> > Martin
> >
> >
> > --
> > MartinShort
> >
> > Software Tester
> > ------------------------------------------------------------------------
> > MartinShort's Profile: http://www.excelforum.com/member.php...o&userid=22034
> > View this thread: http://www.excelforum.com/showthread...hreadid=553793
> >
> >
--
Dave Peterson
Thank you Dave & Martin for your continued support.
Elaine
"Dave Peterson" wrote:
> Saved from a previous post:
>
> Excel tries to help by remembering the last settings you used--except for the
> first search in that session.
>
> You can use that to your advantage.
>
> You could make a dummy workbook and put it in your xlStart folder. Have a
> macro in that workbook that does a find (and sets all the stuff the way you
> like). Then closes and gets out of the way.
>
>
> Option Explicit
> Sub auto_open()
>
> Worksheets("sheet1").Cells.Find What:="", After:=ActiveCell, _
> LookIn:=xlValues, _
> LookAt:=xlPart, SearchOrder:=xlByColumns, _
> 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
>
> But if you do an Edit|Find and change anything, then those changed settings will
> be remembered.
>
> Elaine wrote:
> >
> > Hello Martin,
> >
> > The options button will keep the changes until you exit the program. How do
> > you keep the Search by "Columns", Look in "Values" as permanent defaults? I'm
> > using Excel 2000.
> > --
> > Thank you... Elaine
> >
> > "MartinShort" wrote:
> >
> > >
> > > Click the "options" button and all the extra search parameters will be
> > > displayed
> > >
> > > HTH
> > >
> > > Martin
> > >
> > >
> > > --
> > > MartinShort
> > >
> > > Software Tester
> > > ------------------------------------------------------------------------
> > > MartinShort's Profile: http://www.excelforum.com/member.php...o&userid=22034
> > > View this thread: http://www.excelforum.com/showthread...hreadid=553793
> > >
> > >
>
> --
>
> Dave Peterson
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks