Closing the workbook & saving automatically

Still get the "Do you want to save your changes" message. If I add

Application.DisplayAlerts = False

to the workbookbeforeclose macro, I still get the message.

Just noticed something...these macros are contained on my sheet object. Do they need to be on my workbook object instead?