find and replace, within workbook

M

Matt Carter

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
 
E

exceluserforeman

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

2007 Find_Replace - default on workbook? 0
Word macro that can call cells out of Excel for a find and replace 0
Set the Find and Replace, Options, 'Within' default to Workbook 1
How do I set focus (and select text) on a text box on a modeless userform? 0
How do I change the Excel "search" default to WORKBOOK & DATA? 5
Find within Workbook. 2
Find within an embedded document object 0
Default font for pasted text in text boxes - Excel 2007 0

Top