Disable save changes prompt

I have a file that I don't want people to change at all, so there is no need for them to be prompted whether they want to save changes when closing the file. Does anyone know how to disable this? I found a few supposed solutions on various other forums, including:

Please Login or Register  to view this content.

However, neither of these worked for me. A debug statement in the first showed me that Excel wasn't even getting into it when I went to close the sheet. What's wrong with my syntax?

Thanks very much - the code was perfect. I think that my problem was that I was putting it in the wrong place, so thanks also for specifying the "ThisWorkbook" module.