| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Workbook_BeforeSave Event
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Workbook_BeforeSave Event
I did both a save and a saveas and the SaveAsUI showed TRUE for both. It
shouldn't have? Barb Reinhardt "Jacob Skaria" wrote: 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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Workbook_BeforeSave Event
You must have tried that in a unsaved workbook..Try that in a saved workbook.
If this post helps click Yes --------------- Jacob Skaria "Barb Reinhardt" wrote: I did both a save and a saveas and the SaveAsUI showed TRUE for both. It shouldn't have? Barb Reinhardt "Jacob Skaria" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Workbook.Save triggers event Workbook_BeforeSave and things don't work! | Excel Programming | |||
| Workbook_BeforeSave Event | Excel Programming | |||
| No screen updating in Workbook_BeforeSave event after ActiveWorkbook.Save | Excel Programming | |||
| Problem with Workbook_BeforeSave event | Excel Programming | |||
| Workbook_BeforeSave() | Excel Programming | |||
Linear Mode
