Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a before_save event that runs when I click the save icon on the tool
bar or through the menu. But if I have a command button with this code: Private Sub Save_Click() ThisWorkbook.Save End Sub the Before_save event is called but the files does not save. This is the code for the before_save event: Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean) Dim Fname As String If IsEmpty(Sheet1.Range("F3")) Then _ If IsEmpty(Sheet1.Range("F4")) Then Exit Sub If Not IsEmpty(Sheet1.Range("F3")) Then _ If IsEmpty(Sheet1.Range("F4")) Then _ Fname = Sheet1.Range("F3").Value If Not IsEmpty(Sheet1.Range("F4")) Then _ If IsEmpty(Sheet1.Range("F3")) Then _ Fname = Sheet1.Range("F4").Value If Not IsEmpty(Sheet1.Range("F3")) Then _ If Not IsEmpty(Sheet1.Range("F4")) Then _ Fname = Sheet1.Range("F3").Value & "-" & Sheet1.Range("F4").Value On Error GoTo DumpSub Application.EnableEvents = False Cancel = True Application.Dialogs(xlDialogSaveAs).Show Fname DumpSub: Application.EnableEvents = True End Sub Why would the before_save event work with menu and toolbar commands but not with a save event triggered through code? Thanks, Scott |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Combo Box Event code self triggering?? | Excel Programming | |||
RTD value changes not triggering worksheet change event | Excel Programming | |||
Canceling Workbook Before_Save event | Excel Programming | |||
Before_Save event | Excel Programming | |||
Triggering an event based on reference | Excel Programming |