Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
workbook beforesave event | Excel Programming | |||
Use Workbook BeforeSave Event to Save Copy to Different Location | Excel Programming | |||
Protect Worksheet / Workbook in BeforeSave Event | Excel Programming | |||
BeforeSave sub won't save another workbook when triggered by another event sub | Excel Programming | |||
BeforeSave workbook event | Excel Programming |