| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
filters how do i keep the display list empty until filter applied
When applying filters how do we sow nothing in the spreadsheet until a filter
is applied. Presently it displays all the data when you first open the spreadsheet |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
filters how do i keep the display list empty until filter applied
Possibly hide all sheets except a blank sheet to receive the filter
specification. If you are trying to exclude information from certain users, Excel is not a good choice for this. Possibly store your information in a database, then have excel query that database once the users Identidy is determined. Still, a lot of this would probably depend on code and the user can usually disable code. -- Regards, Tom Ogilvy "Beewfc" wrote: When applying filters how do we sow nothing in the spreadsheet until a filter is applied. Presently it displays all the data when you first open the spreadsheet |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cell reference in the auto filter custom list | Excel Discussion (Misc queries) | |||
| How do I display fractions in a pull down list? | Excel Discussion (Misc queries) | |||
| Display Automatic sentence after filter. | New Users to Excel | |||
| multiple results display after filter function | Excel Worksheet Functions | |||
| Excel Auto Filter: WHY'S SORT @ TOP OF LIST? WHEN I KEY TO "SHOW . | Excel Worksheet Functions | |||
Linear Mode
