How to freeze the Find Options

Good morning,

When I use the search function in Excel (Ctrl+F), and click on the Options button, I see that I have the choice of carrying out the search either in the Formulas, Values or Comments.

However, it seems that by default, the search is always done in Formulas. For example, if I exit Excel and restart it, the search dialog box reappears with the Formula option selected.

Can we prevent this from happening? I would like the search to be done in the Values by default, without needing to modify this parameter each time in the Options

Thanks for your feedback !

Hi,
Installing the addin attached sets the Search option to Values.
If you need to change other options just modify the code.

Please Login or Register  to view this content.

Hope this help