Display a message in system tray
 

Hi All,

Can any one help me to display a message in system tray and close the
workbook once user clicks the close button 'X' in the message?

Here is the actual requirement...
1. Workbook contains employee name and date of birth.
2. The workbook must open (visible false) at 00:01 AM and check the
birthday's on that day. If there are any birthday on that running day display
the employee names in a messagebox at system tray.
3. Once user closes the message then the workbook needs to close
automatically.

If possible please provide script to run macro for every 24 Hrs.

Please share your ideas and thoughts to meet my requirement which can be
appreciated.

Advanced Thanks,
~Vins