find and replace

C

CQL User

Does anyone know how or if you can customize the default display of the
"find and replace" option? I always want it to be configured as:

Find:

Options <<
Within Workbook
Search by Columns
Look in Values

vs. a simple "find what".

So, everytime i open an excel file, and do a find, it pulls up with those as
defaults.

Thanks.
 
S

Susan Ramlet

Well, sadly, I'm not likely to be of much direct help. However:

I don't believe you can do this within the options of Excel (any version),
unless you are willing to write some code to automate the option. That is,
create a macro that does this, and add the macro to your QAT (Quick Access
Toolbar).

That said, I cannot give you the code, as I'm not a developer.

What I'd suggest, however, is that you post to one of the Excel (or
automation) newsgroups, where you'll likely find more folks who have
expertise in these areas. This (office.setup) group is generally more
focused on installation issues around the Office Suite.

Here are some sites that might give you more info about adding macros to the
QAT:
http://www.pschmid.net/office2007/forums/viewtopic.php?t=210
http://www.rondebruin.nl/imageqat.htm

I hope that's helpful, if not as specific as you hoped--
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Word macro that can call cells out of Excel for a find and replace 0
WORD VBA Search and switch to advanced ... 1
How do I set focus (and select text) on a text box on a modeless userform? 0
Need Help with Macro Security 1
ASK Field Formatting 1
Cross-reference Insert Default Change 0
VBA: Macro to find and replace multiple instances of text with form field 0
Slideshow with black border around it 0

Top