About Us

al

Thanks!

"Jacob Skaria" wrote:

From workbook launch VBE using short-key Alt+F11. On the left treeview for
this project double click 'This Workbook' and paste the code to the code
panel.

Private Sub Workbook_BeforeClose(Cancel As Boolean)
If MsgBox("Update File?", vbYesNoCancel + vbQuestion, "File Update") _
< vbYes Then Exit Sub
'Run file update code
MsgBox "File Updated"
End Sub

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

"Al" wrote:

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
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Can I stop the close method in an auto close macro	Paul	Excel Programming	2	November 17th 06 02:48 PM
Don't let user close. Use macro button to close?	mike	Excel Programming	2	October 30th 06 01:31 PM
Do I have to close an odc in a macro?	Tachikrusher	Excel Programming	2	March 3rd 06 02:23 AM
Run Macro on close	Donnie	Excel Programming	6	August 29th 05 09:42 PM
On Close macro	JudithJubilee[_2_]	Excel Programming	14	March 8th 05 09:40 AM

Menu

About Us