Results 1 to 10 of 10

Closing the workbook & saving automatically

Threaded View

  1. #7
    Registered User
    Join Date
    06-08-2005
    Posts
    67
    Got it working mostly with...

    Private Sub Workbook_BeforeClose(cancel As Boolean)
    Application.DisplayAlerts = False
    ThisWorkbook.Save
    End Sub
    When opened in read-only mode, if someone tried to make a change, it closes without saving the changes.
    Last edited by VBA Noob; 01-25-2008 at 02:42 PM.

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