Detecting Save vs SaveAs in BeforeSave
 

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

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

Detecting Save vs SaveAs in BeforeSave
 

Thanks

----- Jim Rech wrote: ----

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

SaveAsUI is False in a Save and True with a SaveAs

--
Jim Rec
Excel MV
"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