How do I run a macro upon saving a file but prior to actual save?
 

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?

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?

How do I run a macro upon saving a file but prior to actual save?
 

Private Sub Workbook_BeforeSave(ByVal SaveAsUI _
As Boolean, Cancel As Boolean)
If Sheets("Sheet1").Range("A1") < 0 Then
Cancel = True
MsgBox "Sheet1 A1 is not zero, save has been cancelled"
End If
End Sub


Gord Dibben MS Excel MVP

On Fri, 6 Jun 2008 11:01:01 -0700, 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?