Telling the difference between save and saveas

[bailey537]

Hi

I am using the beforesave function and I want to determine is the user has saved or saved as, because if they have saved as I want to be able to change a cell to the new file name before they save. Is this possible?

 

[VoG]

Try

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
If Not SaveAsUI Then
'
' do stuff
'
End If
End Sub

 

[bailey537]

cheers will try this and let you know

 

[bailey537]

hi again, is there a way to disable the save as box popping up because i am now using the getsaveas function which pops up the save as box and then i click ok which then draws the filename but then it comes up again after for the actual save as

 

[VoG]

Try like this

Application.EnableEvents = False
'
'getsaveas code
'
Application.EnableEvents = True