View Full Version : A sound on conditional formatting
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
05-26-2008, 05:08 AM
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:
Thanks, looking around on the web I found this, but it sounds for any input value and text too.
sasa
LinkND
05-26-2008, 06:18 AM
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
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.