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.
 
Top