You can not modify the dialog boxes that pop up. The only thing you could do
would be to pre-empt it showing up in the first place. Then you can display
your own form which can look however you want it to...

In the before close event check the saved property. If it is false then you
will need to handle the saving of the file.
--
HTH...

Jim Thomlinson


"Sandy" wrote:

How do I hide or disable the cancel button on the normal "Do you want to
save the changes etc......" dialog box.
I presume code would be inserted into the "Workbook_BeforeClose(Cancel As
Boolean)" module.

TIA
Sandy