sound warning with conditional formatting

  • Thread starter Thread starter Will Fleenor
  • Start date Start date
W

Will Fleenor

I am using conditional formatting to give a warning when I type in a value
that exceeds the range of acceptable values. Is there any way (without
using a macro) to build a formula that will cause a sound effect when
someone types in a value that exceeds the range of acceptable values?

Thanks, Will Fleenor
CFO of K2 Enterprises
 
Dave R. wrote...
Hi, see here;

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

It's not a macro, but it is not a stock function.
Click to expand...
...

Very technically speaking, user-defined functions aren't macros, but t
use them macros must be enabled, so very likely not useful for the OP.
different way of saying this is that it's not possible to play an
sounds in Excel without using VBA.

So, what's the harm in using VBA
 
On problem with this approach (probably something I am doing wrong.). Works
fine in the personal.xls file where I added the function as another module.
However, it will not work in any other file unless I add that function to
that file. Is there any way to get this function to work in all files. I
would have thought that putting it in the personal.xls file would have
accomplished this.

PS Thanks for the help. The works great.

Thanks, Will
Will Fleenor
 
To use the function in another workbook, go to the VB Editor, select your
workbook in the Project pane, then Tools/References and set a reference to
Personal.xls
 
Do you have to do this with every additional workbook you want to use the
function with or is their some way to set it so that is will work with all
workbooks the way Excel macros stored in the personal.xls file work?

Thanks, Will
Will Fleenor
 
Back
Top