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