The Windows Excel App has a search field directly in the blue windows header, which is fantastic.
But the standard search launched is in the sheet and not in the whole excel workbook. As a consequence I have to see the search fail and set the option workbook.
Also I have to exclude some results and I made a VBA Macro for the search, which I included in the ribbon.
Since I doe these searches all through the workday, sometimes every 2 minutes, I would like to streamline even more. I can of course assign a shortcut to the macro, but better yet would be to have the macro called when the search field is updated, instead of the standard search function.
Is that possible ?
Or is it possible to add another search field ?
But the standard search launched is in the sheet and not in the whole excel workbook. As a consequence I have to see the search fail and set the option workbook.
Also I have to exclude some results and I made a VBA Macro for the search, which I included in the ribbon.
Since I doe these searches all through the workday, sometimes every 2 minutes, I would like to streamline even more. I can of course assign a shortcut to the macro, but better yet would be to have the macro called when the search field is updated, instead of the standard search function.
Is that possible ?
Or is it possible to add another search field ?