Detecting Save vs SaveAs in BeforeSave
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As
Boolean)
SaveAsUI is False in a Save and True with a SaveAs.
--
Jim Rech
Excel MVP
"Aaron" wrote in message
...
| Hi,
|
| Is it possible to determine the type of Save requested from a user i.e
Whether it was 'Save' or 'SaveAs' in the BeforeSave event.
|
| Thanks,
| Aaron
|