Workbook BeforeSave
in [Programming]
|
Prev: When does conditional formating fire?
Next: Code for emailing Excel workbooks will only attach activeworkb
From: Barb Reinhardt on 20 Jan 2010 14:52 Is there some way to prevent saving under certain conditions int he workbook_before save method? Thanks, Barb Reinhardt
From: Chip Pearson on 20 Jan 2010 15:03 Barb, Put the tests in the BeforeSave event in ThisWorkbook and if the tests indicate that the Save should be prevented, set the Cancel parameter that is passed into BeforeSave to True. Cordially, Chip Pearson Microsoft MVP 1998 - 2010 Pearson Software Consulting, LLC www.cpearson.com [email on web site] On Wed, 20 Jan 2010 11:52:02 -0800, Barb Reinhardt <BarbReinhardt(a)discussions.microsoft.com> wrote: >Is there some way to prevent saving under certain conditions int he >workbook_before save method? >Thanks, > >Barb Reinhardt
From: John on 20 Jan 2010 15:17 What are the conditions? Can you test for them with and IF statement? or put an if statement in a cell value and test if that cell has a value in the code? "Barb Reinhardt" wrote: > Is there some way to prevent saving under certain conditions int he > workbook_before save method? > Thanks, > > Barb Reinhardt >
From: Ryan H on 20 Jan 2010 15:31 Yeah that is possible. But I'm not sure what conditions you are wanting to test so I assumed one. Put this in the before save event. Hope this helps! If so, let me know, click "YES" below. Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean) If Sheets("Sheet1").Range("A1").Value = "Don't Save" Then Cancel = True End If End Sub -- Cheers, Ryan "Barb Reinhardt" wrote: > Is there some way to prevent saving under certain conditions int he > workbook_before save method? > Thanks, > > Barb Reinhardt >
From: Barb Reinhardt on 20 Jan 2010 15:32
I figured it out. I forgot to include CANCEL = TRUE when I didn't want to save. Thanks, Barb Reinhardt "John" wrote: > What are the conditions? Can you test for them with and IF statement? or put > an if statement in a cell value and test if that cell has a value in the code? > > "Barb Reinhardt" wrote: > > > Is there some way to prevent saving under certain conditions int he > > workbook_before save method? > > Thanks, > > > > Barb Reinhardt > > |