View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jacob Skaria Jacob Skaria is offline
external usenet poster
 
Posts: 8,520
Default Workbook_BeforeSave Event

Hi Barb

In the below workbook event SaveAsUI will return True

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

If this post helps click Yes
---------------
Jacob Skaria


"Barb Reinhardt" wrote:

I want to do some other actions when I do a "SAVEAS". Can someone remind me
how to capture that in the BeforeSave event?

Thanks,

Barb Reinhardt