| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Set Find to look in Values instead of Formulas by default?
Is there a setting somewhere that I can use to default Find to search-
in-values instead of search-in-formulas? I would like to be able to turn this on via code, so that every time the user uses Find it has defaulted to this setting. If you're wondering, turning this on also makes Excel ignore data in hidden columns. I have lots of data in hidden columns that I don't want the user to Find unless they really go looking for it. Maury |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel is pasting values, not formulas by default | Excel Discussion (Misc queries) | |||
| Find "Look in" box does not show 'values' on 'formulas' | Excel Worksheet Functions | |||
| Changing Default Search in to Values Not Formulas in Excel | Excel Discussion (Misc queries) | |||
| changing formulas to values so that they will be recognized by Find and Replace | Excel Discussion (Misc queries) | |||
| find replace cursor default to find box | Excel Discussion (Misc queries) | |||
![Maury Markowitz[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
