run macro when closing file
 

I need a maacro to turn off autofilters when file is closed.

run macro when closing file
 

Look in the ThisWorkbook module for before_close

--
Don Guillett
SalesAid Software

"santee" wrote in message
...
I need a maacro to turn off autofilters when file is closed.

run macro when closing file
 

Use the workbook beforeclose event

http://www.cpearson.com/excel/events.htm
for an overview of events.

--
Regards,
Tom Ogilvy


"santee" wrote:

I need a maacro to turn off autofilters when file is closed.