Set Excel to search within entire workbook by default
Set Excel to search within entire workbook by default
Set Excel to search within entire workbook by default
Re: Set Excel to search within entire workbook by default
You can do this with a Workbook_Open macro in the ThisWorkbook module, like so:
```
Private Sub Workbook_Open()
Application.CommandBars.FindControl(ID:=1849).Execute
SendKeys "%(h){DOWN}{ENTER}{ESC}"
End Sub
```
This will set it for your session for the workbook you're in.
To have this always be the default you need to create a [Personal Macro Workbook](https://www.rondebruin.nl/win/personal.htm).
Note: Old line from original answer: `SendKeys "%(t)%(h)W~{ESC}"`
```
Private Sub Workbook_Open()
Application.CommandBars.FindControl(ID:=1849).Execute
SendKeys "%(h){DOWN}{ENTER}{ESC}"
End Sub
```
This will set it for your session for the workbook you're in.
To have this always be the default you need to create a [Personal Macro Workbook](https://www.rondebruin.nl/win/personal.htm).
Note: Old line from original answer: `SendKeys "%(t)%(h)W~{ESC}"`