View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default 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?