Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Run macro brfore close
Hello
I would like to run this code before the file is closed. Sub Update() Msg = "Update File?" Title = "File Update" Response = MsgBox(Msg, vbYesNoCancel + vbQuestion, Title) If Response = vbNo Then Exit Sub End If If Response = vbCancel Then Exit Sub End If Run file update code MsgBox "File Updated" End Sub How do I do this? Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I stop the close method in an auto close macro | Excel Programming | |||
Don't let user close. Use macro button to close? | Excel Programming | |||
Do I have to close an odc in a macro? | Excel Programming | |||
Run Macro on close | Excel Programming | |||
On Close macro | Excel Programming |