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

  • Thread starter Thread starter Paffer
  • Start date Start date
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.
 
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.
 
Back
Top