Hi Sheldon.

The "X" you refer to closes the workbook, not a sheet. The topmost "X"
closes the Excel Application.

I have created a macro that closes the worksheet

Please show your code! I do not beleive that it is possible to close a
worksheet in isolation from its parent workbook.


---
Regards,
Norman



"Sheldon" wrote in message
...
I guess I need to be more specific. I want to prevent the automatic action
that takes place when the user clicks on the "X" in the top right of the
worksheet (NOT the workbook - that's ok to use). I have created a macro
that
closes the worksheet and does some other operations.

Thanks

"Sheldon" wrote:

How do I prevent or disable in code a worksheet close, not a workbook
close?

Thanks