ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   want AutoFilter to default "on" for all columns (https://www.excelbanter.com/excel-programming/338010-want-autofilter-default-all-columns.html)

John Jones[_2_]

want AutoFilter to default "on" for all columns
 
From ASP.NET I set Response.ContentType = "application/vnd.ms-excel" then
Response.Write (some_excel_data). Excel opens in a new IE window. Is there
some way for AutoFilter to automatically default "on" first thing when excel
opens?

Tom Ogilvy

want AutoFilter to default "on" for all columns
 
It should be in the same state as when the file was saved.

--
Regards,
Tom Ogilvy


"John Jones" wrote in message
...
From ASP.NET I set Response.ContentType = "application/vnd.ms-excel" then
Response.Write (some_excel_data). Excel opens in a new IE window. Is

there
some way for AutoFilter to automatically default "on" first thing when

excel
opens?





All times are GMT +1. The time now is 09:50 AM.

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