ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   save search settings having all tabs selected-or entire workbook (https://www.excelbanter.com/excel-worksheet-functions/132812-save-search-settings-having-all-tabs-selected-entire-workbook.html)

Kens

save search settings having all tabs selected-or entire workbook
 
how do I save settings in a workbook so when i search it selects the entire
workbook vs. an individual sheet of the workbook.
Choices are to right click a tab and select the SELECT ALL SHEETS
or
Use the FIND and go to advanced settings and say search workbook vs. search
sheet.
problem is each time you open the workbook you must go thru this again. how
does one save the settings once you set them?



All times are GMT +1. The time now is 09:26 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com