+ Reply to Thread
Results 1 to 6 of 6

Message box pops when another workbook modified or saved

  1. #1
    Forum Contributor thameem127's Avatar
    Join Date
    04-06-2012
    Location
    Jeddah,Saudi Arabia
    MS-Off Ver
    Excel 2003,Excel 2007
    Posts
    321

    Message box pops when another workbook modified or saved

    Dear Experts,


    I need coding for message box pops in a workbook when another workbook modified or saved.
    Last edited by thameem127; 09-17-2012 at 01:24 PM.

  2. #2
    Registered User
    Join Date
    09-16-2012
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    7

    Re: Message box pops when another workbook modified or saved

    Quote Originally Posted by thameem127 View Post
    Dear Experts,


    I need coding for message box pops in a workbook when another workbook modified or saved.
    another workbook ??? means?
    can you explain clearly..

  3. #3
    Forum Contributor thameem127's Avatar
    Join Date
    04-06-2012
    Location
    Jeddah,Saudi Arabia
    MS-Off Ver
    Excel 2003,Excel 2007
    Posts
    321

    Re: Message box pops when another workbook modified or saved

    That means another file.

    I have two files.One is Main file is in Shared folder- Network and another file (personal)is in my desktop . The message box should pops up in my personal file when the main file in public folder is modified.

  4. #4
    Forum Contributor thameem127's Avatar
    Join Date
    04-06-2012
    Location
    Jeddah,Saudi Arabia
    MS-Off Ver
    Excel 2003,Excel 2007
    Posts
    321

    Re: Message box pops when another workbook modified or saved

    Still I am waiting for the answer.

  5. #5
    Registered User
    Join Date
    09-16-2012
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    7

    Re: Message box pops when another workbook modified or saved

    hi, thameem

    Below Code in "ThisWorkbook" can popup message

    Please Login or Register  to view this content.
    but have to workout how to link this vba to another workbook

  6. #6
    Forum Contributor thameem127's Avatar
    Join Date
    04-06-2012
    Location
    Jeddah,Saudi Arabia
    MS-Off Ver
    Excel 2003,Excel 2007
    Posts
    321

    Re: Message box pops when another workbook modified or saved

    Any way thanks for your answer but this is not what I required.
    Last edited by Cutter; 09-18-2012 at 06:54 PM. Reason: Removed whole post quote

+ 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