A sound on conditional formatting

[sasa]

Hi All.
I have a large sheet were some rows get green when the value inside the cell
is equal to 1.
Is it possibile to associate a little sound (maybe a sweet sound) to the same event ?
It would be very useful when the sheet is very large so that every time I have to scroll this to verify the changing colours.
Any help is appreciate.
sasa

[LinkND]

Hi All.
I have a large sheet were some rows get green when the value inside the cell
is equal to 1.
Is it possibile to associate a little sound (maybe a sweet sound) to the same event ?
It would be very useful when the sheet is very large so that every time I have to scroll this to verify the changing colours.
Any help is appreciate.
sasa

How about this from the official website of Microsoft?

http://support.microsoft.com/kb/211842

If you want to use this, you can try calling the sub after the main sub for filtering == 1. I think there is a better way to try this out, but this should help you started :think:

[sasa]

Thanks, looking around on the web I found this, but it sounds for any input value and text too.

sasa

[LinkND]

I can't test it right now, because I don't have any sound on this computer from the company I am graduating at.

But this looks okay to me... maybe you can check this out!

http://www.j-walk.com/ss/excel/tips/tip87.htm