find and replace

[rdh2378]

When you choose "find" in msexcel 2003, you can choose options, and change
from the default "within sheet" to "within workbook". Can you modify excel
to have the default option to be to search w/n workbook?

 

[Dave Peterson]

Sometimes you can use excel's memory against itself.

Excel remembers the setting from the last edit|replace--whether it was done
manually or via code. But this is one setting that isn't exposed to code.

So I don't think you can change this behavior/default.

===
If you knew that the options were showing in that dialog, you could use a macro
and sendkeys to select Workbook.

Option Explicit
Sub testme()
SendKeys "%hw{enter}"
Application.CommandBars("worksheet menu bar") _
.Controls("Edit").Controls("Replace...").Execute
End Sub


But this fails if the Options aren't showing on that dialog.