find and replace, within workbook

G

Guest

Is there a registry hack excel, find and replace, within workbook
I do Ctrl-F to search and get to the Find and Replace dialogue box and
select in Excel 2003 SP2 the Options > > button. It will expand the dialogue
box a bit more.
After the expansion, it displays the three drop down fields and the two
check boxes. I would like to set it so it searches by default Within:
Workbook instead of Within: Sheet (the default).
I have multiple workbooks and would like to search for all of them.
Is there a registry hack to set to 0 or 1 that will change from Sheet to
Find and Replace Within: Workbook
 
G

Guest

Record a macro on your actions and modify to suit. Apply this macro to a
toolbar button and stick it in your Personal.xls
 

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

Set the Find and Replace, Options, 'Within' default to Workbook 1
Find within Workbook. 2
find and replace within a hyperlink 8
Merge Multiple workbook sheets into one workbook 0
Find and Replace in VBA 3
How do I change the Excel "search" default to WORKBOOK & DATA? 5
Toggle between Find and Replace 4
Change Excel Find & Replace Options Defaults 1

Top