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.
rdh2378 wrote:
[Quoted Text] >
> 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
|