[dba-Tech] Excel question, from a reader

I've been looking for an answer to that one for ages. Love to hear any solution. Though perhaps a simple AutoExec macro would do it.

Lambert 

-----Original Message-----
From: dba-tech-bounces at databaseadvisors.com [mailto:dba-tech-bounces at databaseadvisors.com] On Behalf Of Susan Harkins
Sent: Thursday, August 12, 2010 12:36 PM
To: Discussion of Hardware and Software issues
Subject: [dba-Tech] Excel question, from a reader

"Excel Find and Replace Defaults
How do you permanently change the default values in the Options section of Find and Replace in Excel? I have to manually change the values EACH time I start Excel.

Currently "Search:" is defaulted to "By Rows". I want the default to permanently be "By Columns".

Currently "Look In:" is defaulted to "Formulas". I want the default to permanently be "Values".

My suspicion is this can only be changed by a change in the program code because Microsoft in it's so-called wisdom decided this isn't important for users and failed to put in a "Set As Default" option that allows the user to set the default options desired."

=========I haven't checked any options, but I suspect this can't be done -- maybe through a registry hack, but I don't think I recommend that to the average user. Might be simplier to just bypass the built-in interface and use a custom form to solicit the values. I do think this feature should be more flexible, and maybe it is -- I'll look a bit later, but if someone knows off the top of their head, please share! Thanks!
Susan H. 
_______________________________________________
dba-Tech mailing list
dba-Tech at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-tech
Website: http://www.databaseadvisors.com