On Apr 26, 12:56*pm, Raja wrote:
Hello,
Is there a way to know in beforeSave Event what the you choose in the SaveAs
menu?
*I mean whether he chooses Excel workbook, Excel workbook with macro or Binary

Raja - not sure what you are trying to do, but there is a ThisWorkbook
event:

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean,
Cancel As Boolean)

End Sub

That might do what you want to do...