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

Need Help with Macro Security 1
Word macro that can call cells out of Excel for a find and replace 0
How do I set focus (and select text) on a text box on a modeless userform? 0
WORD VBA Search and switch to advanced ... 1
2007 Find_Replace - default on workbook? 0
Start sheet in a workbook 2
Save workbook without shapes 0
Section and Page numbering 0

Top