How can I disable the close (x) button of an excel sheet
(not Excel Application) using VBA?

TIA

Soniya

Tools | Protect Workbook | Windows.

BTW, some of these questions can be answered very easily by doing a search
on Google.

http://www.google.com/advanced_group_search?hl=en

Use "close button disable" as the search words and "*excel*" as the
newsgroup (both without the quotes).

Regards,

Vasant.
.