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