| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I print sheet , with actual file save date in footer? | Excel Worksheet Functions | |||
| accidental save - recover prior version of Excel file? | Excel Discussion (Misc queries) | |||
| Save as prompt missing saving a .csv file | Excel Discussion (Misc queries) | |||
| formula for month(s) prior to actual | Excel Worksheet Functions | |||
| formula for month that is prior to actual | Excel Worksheet Functions | |||
Linear Mode
