Thread: run macro when closing file
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
  
Posts: 6,953
Default 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.
Reply With QuoteReply With Quote