sound warning with conditional formatting

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
 
H

hgrove

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
 
W

Will Fleenor

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
 
M

Myrna Larson

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
 
W

Will Fleenor

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
 
Top