+ Reply to Thread
Results 1 to 5 of 5

Creating Message Box after Saving

Hybrid View

  1. #1
    Forum Guru
    Join Date
    08-26-2007
    Location
    London
    Posts
    4,606

    Re: Creating Message Box after Saving

    If I understand correctly, put this in the ThisWorkbook module (see VBE Project window):
    Private Sub Workbook_BeforeClose(Cancel As Boolean)
    
    x
    
    End Sub
    
    Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
    
    x
    
    End Sub
    and this in a normal module
    Sub x()
    
    MsgBox "Text here", vbOKOnly
    
    End Sub
    But what is the point of this?
    Last edited by StephenR; 11-17-2010 at 12:03 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1