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?