+ Reply to Thread
Results 1 to 2 of 2

Excel Alert notification

  1. #1
    Registered User
    Join Date
    06-10-2007
    Posts
    1

    Excel Alert notification

    Hi, i have a chart where it shows a list of items and dates remaining before it is inspected...(i do not have time to look at the list on a daily basis) Is there any way that Excel can notify or alert me before the items are expired? via either a pop-up window message or email notification...ANY help would GREATLY APPRECIATED ... I think i have the newer version of excel 2003 or above...Thanks.

  2. #2
    Forum Contributor
    Join Date
    01-21-2005
    Location
    Colorado
    MS-Off Ver
    2000,2003,2007
    Posts
    481
    You could add a Workbook_Open event macro to the Personal project in the VBA editor. This will then run each time Excel is opened and check your dates
    remaining against the current date and alert you with a message box as
    appropriate.

    HTH

+ 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