Thread: How do I run a macro upon saving a file but prior to actual save?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
FSt1 FSt1 is offline
external usenet poster
  
Posts: 3,942
Default How do I run a macro upon saving a file but prior to actual save?
hi
yes there is a before save event. it is thisworkbook code so paste your
macro in the thisworkbook-beforesave

Regards
FSt1


"Hawk186" wrote:

Excel 2003 - The user does not want the file to be allowed to save if the
value in a given field does not equal zero. Is there a way to run a macro
when a save is executed?
Reply With QuoteReply With Quote