Sound Alert

[Raj Mukherji]

Hi Guys,

Is it possible to auto activate a sound alert linked with any prefixed cell due to change in date. For Example, renewal of insurance policy of a vehicle say yet to happen on 11.08.2014, and i have set an indicator cell indicating an alert 10 days before. Now, saying this I want to activate a macro which will be linked to that changed cell and when the cell value is changed an automatic voice alert will play naming the vehicle No, last day of policy renewal, vehicle name, person name etc, like this.

Kindly help me as I am able to run a macro towards color change but unable towards voice alert.

Moreover, kindly also note that I am using XL 2007 version.

Regards,
Raj.

[Tinbendr]

Here's an article about that.