Is there some way to prevent saving under certain conditions int he
workbook_before save method?
Thanks,

Barb Reinhardt

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
wrote:

Is there some way to prevent saving under certain conditions int he
workbook_before save method?
Thanks,

Barb Reinhardt

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

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

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