Just trying to Beep..

I'm trying to get excel to Beep on condition (then eventually play a sound file)

But I cant even get excel 2007 to do a simple beep

I right click my sheet, view code:

Function beepNow()
beep
End Function

Then in my excel sheet, I put something like :::: IF(A1 < 5, beepNow(),"")

Is this correct?
For some reason, I see "Beep" (instead of "beep") on all the tutorials, but excel refuses to let me use Beep and keeps changing it to lowercase.

Thanks for the help.

[edit]: the error the cell gives is "#NAME?"

Make the function public:

Please Login or Register  to view this content.

Weird, It still doesn't work for me

I tried making it public. Still #NAME?

I tried using semicolons ; . Got a syntax error.

Does my excel not have beep?

[edit:] am I putting it the right place? right click sheet, view code and just type it in there
[edit2] it seems like excel cant find my function beepNow

Does your computer beep on boot? If not, the internal speaker may either be disconnected or else is not working. Also, check to make sure your system volume is turned on.

Going out on a limb here... make sure your calculations are set to automatic. Merely reentering the formula will be enough to get it to calculate for that cell, so it shouldn't matter, but let's double check.

or as an option

Please Login or Register  to view this content.

I don't have that option checked, but it beeps for me. I doubt that has anything to do with it since the Beep function is deep in your machine and runs at boot during the POST operation. Shouldn't matter.

Make sure it's in an ordinary code module. Copy all code to the clipboard. From your visual basic editor, click insert|module, then paste.

Bingo. I just tried that with macros disabled and immediately got the #Name? error.

Also, you may have to recreate the book since saving, closing, reopening has no effect - you'll still get the error. Shut down Excel, start a new session, then recreate the function. Make sure macros are enabled before you do this.

From Microsoft:
http://office.microsoft.com/en-us/ex...010354326.aspx

That is the case. Once a book is opened, enabling the macro won't do any good from the trust center. If you make that setting change with the book closed, it should work. Is it working for you now?

Cheers!
Tom

See if this helps (untested):

Please Login or Register  to view this content.

You'll need to play with the WAVFile reference to make sure the file exists, and you'll want to confirm it's saved in the same location as your workbook...