What have I done?

[Fan924]

I had to uninstall and reinstall Office 97. It was crashing randomly.
I have the Analysis Toolpak installed and macros enabled. Now, My
macros are not working correctly. Many errors. The example below, It
moves the number to A4 correctly ....but not to A5 and no beep. Yes,
it all worked correctly before I reinstalled Office.

Sub Size20()
Range("A4").Value = "4096"
Range("A5").Value = "4096"
Beep
End Sub

 

[Billy Liddel]

I just ran the macro and it worked OK but I needed the speakers on. Also the
beep is more like a beat on a small drum. Perhaps the sound has changed since
97, I ran it on xl2003.

Peter