irritated

T

timwight

At least 90% of the occasions I use Edit > Find, I want to search by
column and look in values. I therefore 'find' it irritating that my
search defaults to rows and look in formulas. Can anyone suggest how
to change these defaults?

While I'm on the subject of defaults, anyone know how to amend the boot
time value of Autosave Period. I would like to default to 30 mins, I
have tried changing the Registry key but it keeps resetting itself to
10 minutes.

Cheers

Twig
 
M

Miyahn

At least 90% of the occasions I use Edit > Find, I want to search by
column and look in values. I therefore 'find' it irritating that my
search defaults to rows and look in formulas. Can anyone suggest how
to change these defaults?
Click to expand...

Attach the following procedure to the user defined menu or toolbar button
or shortcut key.

Sub MySearch()
Dim Result
With Application.Dialogs(xlDialogFormulaFind)
Result = .Show(, 2, 2, 2, , False, False)
End With
End Sub
While I'm on the subject of defaults, anyone know how to amend the boot
time value of Autosave Period. I would like to default to 30 mins, I
have tried changing the Registry key but it keeps resetting itself to
10 minutes.
Click to expand...

If your Excel's version is 2000,
http://support.microsoft.com/kb/231117/en-us
 
E

EdMac

With reference to your query on auto save - have you looked in Help?

Alternatively just go to tools > options > save and change the settin
- it works for me.

HTH

E
 
T

timwight

Thanks Miyahn

If I have to code a solution then I may as well create an alternativ
Find/Replace dialog with my preferred defaults.

Looking beyond EdMacs sarcasm, he has also been helpful. Having 'cu
my teeth' on earlier versions of Excel I had the Add In Autosav
installed in Excel 2002, not having noted the feature is now built in
(used to be the first thing to load after an excel installation). Th
add in seems to havee priority over the built in feature, includin
period setting and including not saving between sessions. Removing th
add in has solved the problem.

So thanks both

Twi
 
Top