Unusual Bug with DDE and Excel Scripts in MT4

While using an Excel sheet linked to MT4 via DDE, such as the one provided as a sample with the MT4 program, I have it working fine. When I add a script by going into the visual basic editor and placing it into the code area for the sheet, it continues to work fine, and the script also runs ok. HOWEVER, once I exit out of the sheet and reload it, none of the DDE updated cells will update anymore. If I exit the sheet without adding any code and reload it, it would work fine. The problem only occurs when adding a script, AND THEN exiting.

So for now I am just going to paste the entire sheet once again onto the sample DDE sheet after every time I turn my computer off, but would really like to know why this is happening. This happen to anybody else?

I'm running Excel 2000 and can open xls. If you have an xls post it and I will look at it. If it is an xlsa I can not open it. Ken.

Thanks so much! Here is the sample sheet that is included with MT4. I added the code, and you can see this will not update. If you dont have an ATC broker account running this may not work for you even normally, but you can place the code in your own sample version and see what i mean.

The code is for an alert to say "the price is right" whenever cell b15 is greater than "0". You can test this by placing a "1" in cell B16 which I linked to b15, this will change cell b15 to 1 and the alert will sound. Not sure why this disables the DDE...
Thanks again for the kind offer.
Edit: Almost forgot to mention that if you place the code onto the sheet DDE will still work as long as the sheet stays open, but when you close it and try to reload it the DDE will not work. On the sheet I sent the code is already in place so it should not work at all, but if it does work for some reason try saving and exiting, and then reloading it, and it should not work.

If Range("B15").Value > 0 Then
'Application.Speech.Speak "The price is right"
Range("D17").Value = Time() & ", " & "The price is right"
Else
Range("D17").Value = Time() & ", " & "Waiting on right price"
End If
=======================================
Will this even compile? My Excel does not have that "Speech" module - maybe it came out in a later release (looking at help sound has been removed!), but, this works for me before and after saving. Are you running Vista - lots of weird stuff happends with the "new and improved" OS. There is a way to play a wav file in Excel (let me know if you want it), or you can just sound the beep-er a few times.
Dim I
For I = 1 To 3 ' Loop 3 times.
Beep ' Sound a tone.
Next I

Very interesting. I would love to try it with the beeping or tone as you did it to see if it works...as I am pretty clueless when it comes to stuff like this, could you please tell me how I would insert that code you showed into my code, to switch out the voice for the beeping? The WAV file would also be cool to try.

Oh and I am running Excel 2007 with Windows XP home. Thanks so much...

Just insert the code for the beep after the first If statement. I will post the code for playing a wav file later today.

OK I used the beeping code and after I saved and exited and came back the DDE was no longer working, just like before. For some reason having a script running just messes with any new DDE connections, I guess. Pasting everything to a fresh sheet isnt too much of a hassle I guess, since I only need to do it once a week or so when I shut my computer down. Thanks for all of your help though, I really appreciate it!

I suspect it has something to do with security - in tools options set security to it's lowest level. Also, when the dde is not working, is the formula still correct in the cell? "=MT4 etc etc" ?? Post the xls that is not working.

Hmm I tried the security thing, doesnt seem to help. The first sheet I posted has the same code etc. and that one seems to work for you, but not me. The names remain corect, though I remember once when i was fooling around these little ' marks would appear before and after "MT4" in the formula, and I couldnt get rid of them..though I cant seem to replicate that problem now.