Set the Find and Replace, Options, 'Within' default to Workbook

P

Paffer

I want to set the Find and Replace, Options, 'Within' default to Workbook,
rather than Sheet so that it is automatically set to Workbook each time Excel
is started.
Using Microsoft Ofice Excel 2007.
 
D

Dave Peterson

Excel won't let you do this by anything built into it.

Maybe you can use a macro and use Sendkeys, but I wouldn't bother. Sendkeys is
not reliable.
 

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

find and replace, within workbook 1
How do I change the Excel "search" default to WORKBOOK & DATA? 5
find and replace within a hyperlink 8
Find within Workbook. 2
Start sheet in a workbook 2
Find and Replace in VBA 3
Find and Replace - Options 1
Merge Multiple workbook sheets into one workbook 0

Top