Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 25
Default running macro at save/close/exit

running macro at save/close/exit
Microsoft Excel 2003
  #2   Report Post  
Posted to microsoft.public.excel.programming
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
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro to save and close, then copy file NewSysAdmin Excel Discussion (Misc queries) 2 December 2nd 09 03:24 PM
Write macro don't ask to save when exit excel Rui Alvares Excel Programming 0 March 29th 06 12:50 AM
Macro: Exit active workbook without save? Don Excel Worksheet Functions 0 May 20th 05 06:47 AM
Macro to Close and save all changes Souljah[_5_] Excel Programming 4 June 8th 04 02:39 AM
Close and save macro Gordon Cartwright Excel Programming 2 November 25th 03 12:15 AM


All times are GMT +1. The time now is 12:04 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"