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.

Paffer wrote:

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.

--

Dave Peterson