Thread: running macro at save/close/exit
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Mike Mike is offline
external usenet poster
  
Posts: 3,101
Default running macro at save/close/exit
In your VB Project Explorer, double click the "ThisWorkbook" icon
You should then see a two dropdowns at the top of the page. First, click
the one that says "(General)"...
Change that to "Workbook"

Next Go to the Drop down to the right of that one and select, BeforeSave or
Open or Activate or whatever.

"Pedro" wrote:

running macro at save/close/exit
Microsoft Excel 2003
Reply With QuoteReply With Quote