View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Libby Libby is offline
external usenet poster
 
Posts: 151
Default Auto Filter memory

Hi Guys,

I have a workbook which is used by multiple users. They can all save
changes, but I don't want the workbook saved with filters in place.
Sometimes filters are used. The filters are always on row 5 and on 35 columns.
Is there anyway, when someone saves the workbook, that the filters in place
could be "memorised", the workbook saved and the previous filter settings
then applied?

All help much appreciated!