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

  • Thread starter Thread starter Hawk186
  • Start date Start date
H

Hawk186

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?
 
hi
yes there is a before save event. it is thisworkbook code so paste your
macro in the thisworkbook-beforesave

Regards
FSt1
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2007: Saving a file with a Macro 1
Excel 2003 save as .XLSX 10
Tracking Access in Read-Only Files 0
Macro to save file with Active Document Name 4
How do I save a file with decimal number 2
Saving a worksheet 2
Excel Fast Save 4
Run "Workbook Open" once 5

Back
Top