How to disable save message when I click the cross to close the file

Dear all,
When I close a excel file by click the cross on the left
top corner, excel will prompt me to save the file or not. I want the
excel not to save the file and not to prompt me to save. How can I
disable the save message when I press the cross to close the excel
file?

Thanks.

Peter,
There is the Workbook_BeforeClose event:
ThisWorkbook.Saved=True

NickHK

"hon123456" <[email protected]> wrote in message
news:[email protected]...
> Dear all,
> When I close a excel file by click the cross on the left
> top corner, excel will prompt me to save the file or not. I want the
> excel not to save the file and not to prompt me to save. How can I
> disable the save message when I press the cross to close the excel
> file?
>
> Thanks.
>

Thanks NickHK

NickHK =E5=AF=AB=E9=81=93=EF=BC=9A

> Peter,
> There is the Workbook_BeforeClose event:
> ThisWorkbook.Saved=3DTrue
>
> NickHK
>
> "hon123456" <[email protected]> wrote in message
> news:[email protected]...
> > Dear all,
> > When I close a excel file by click the cross on the left
> > top corner, excel will prompt me to save the file or not. I want the
> > excel not to save the file and not to prompt me to save. How can I
> > disable the save message when I press the cross to close the excel
> > file?
> >
> > Thanks.
> >