Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Thanks Tom. One more question -
What if the user selects Save As? Does that throw a monkey wrench in the code? "Tom Ogilvy" wrote in message ... That would be the basic approach. -- Regards, Tom Ogilvy "Steph" wrote in message ... Thanks for all of your help. Just to confirm - by combining the suggestions of your posts, is the below code the proper way to perform the After Save Event? Thanks! Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean) Cancel = True '<Optional - this would be before save code application.enableevents = false ThisWorkbook.Save application.enableevents = true '<Optional - this would be after save code End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Another Save Question | Excel Worksheet Functions | |||
save as text question | Excel Discussion (Misc queries) | |||
Another save as question | Excel Programming | |||
Save Macro - yet another question | Excel Discussion (Misc queries) | |||
A save question: | Excel Programming |