Results 1 to 3 of 3

Thread: Track changes

  1. #1
    Join Date
    Apr 2004
    Location
    Singapore
    Posts
    5

    Red face Unanswered: Track changes

    Hi all,

    I know that excel can track changes for shared workbook but I am looking for something more foolproof.

    Are there anyway for excel to notify me of any changes made to my shared excel workbook through outlook? Or Can I prevent other users from saving my workbook under another name? Or....

    My workbook is being shared by a lot of people, both from my dept as well as other depts. My main concern is unauthorise tampering or sabotage.

    Please help.


    Thanks,
    Mus

  2. #2
    Join Date
    Jan 2004
    Location
    Aberdeen, Scotland
    Posts
    1,067

    Re: Track changes

    I have a Way of e-mailing via VBA

    Code:
    'Uses Microsoft Outlook 8 reference
    Sub Sendmail()
        Dim appOutLook As Outlook.MAPIFolder
        Dim oMailItem As Outlook.MailItem
        Dim oContact As Outlook.Recipient
        
        'create application and Mail Item
        Set appOutLook = GetObject("", "Outlook.Application").GetNamespace("MAPI").GetDefaultFolder(olFolderInbox)
        Set oMailItem = appOutLook.Items.Add
        
        'set mail properties
        With oMailItem
            .Subject = "Message Subject"
            Set oContact = .Recipients.Add("user@email.com")
            oContact.Type = olTo
            .Body = "Message Subject"
            .Send
        End With
        'dispose of objects
        Set oContact = Nothing
        Set oMailItem = Nothing
        Set appOutLook = Nothing
    End Sub
    if you set the refrence to Outlook from the tools menu.
    you could set a routine to call this from a worksheet_change event.

    To stop saving you could investigate the Workbook_Beforesave Event.
    Possibly by Password protecting the save event.

    Hope this Helps

    David

  3. #3
    Join Date
    Apr 2004
    Location
    Singapore
    Posts
    5

    Re: Track changes

    Hi David,

    Thanks for the response. Will give your suggestion a whirl!

    Mus

Posting Permissions

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