Set Default Find Within : Workbook

[Debraj]

Hi Folks,


Can anyone have any Tweak or RegEdit to set Default Find > Option > Within > Workbook..


I mean.. is there any option to

set Application.Find("Something", LookAt:=

xlWhole) .. as default for my system..


Its really annoying to set Search Within Workbook everytime.. When I know.. setting Search Within Workbook.. I can handle if active sheets changes..


Regards,

Deb

 

[Luke M]

Hi Deb,

I'd ditto your question, I've been searching for several years for a way to programatically do a

Find

on the whole workbook. It appears to not have an actual method. =(


One workaround I would suggest is to setup a custom sub in your Personal.xls workbook scripted to take a workbook and then loop through all worksheets searching for input value. Then map it to the keyboard shortcut of Ctrl+f or perhaps, Ctrl+Shift+f

 

[vasim]

Findall addin should do this....you can assign a shortcut through ribbons if required...


http://www.cpearson.com/Excel/findallxla.aspx


The code is password protected.

 

[Debraj]

oops.. i missed to announce the result.. Sorry..


Personal.XLSB > This Workbook >

[pre]

Private Sub Workbook_Open()
Application.CommandBars.FindControl(ID:=1849).Execute
SendKeys "%(t)%(h)W~{ESC}"
End Sub

[/pre]

Regards,

Deb


EDIT: applicable in Excel 2007 and prior..

 

[SirJB7]

Hi, Debraj Roy!

Nice trick, chapeau, monsieur...

Regards!

 

[Debraj]

Hi SirJB007..


After a long time.. I got praise from you..

Thanks..


Regards,

Deb

 

[SirJB7]

Hi, Debraj Roy!

Well deserved in this case. I guess that as usual, I wouldn't like to appear as an easy flattering.

Regards!