How do I change the Excel "search" default to WORKBOOK & DATA?
"Shane Devenshire" wrote:
Hi,
Here is one way:
Sub myFind2()
SendKeys "%E{Enter}F"
SendKeys "%HW{Enter}"
SendKeys "%LV{Enter}"
SendKeys "%N{Enter}"
End Sub
If you assign this to a toolbar button or give it a shortcut key it will do
what you want. Personally I don't like using SendKeys because this might
work in 2003 but not in 2007 or a later version.
--
If this helps, please click the Yes button.
Cheers,
Shane Devenshire
"danny bromberg" wrote:
How do I change the Excel "search" default so that WITHIN WORKBOOK and LOOKIN
DATA appear when I click on the OPTIONS (instead of the default WITHIN SHEET
and LOOKIN FORMULAS)?
|