You cannot cancel the deactivate, so you would need to capture the active
worksheet, and then restore that if it is deactivated.

--

HTH

RP

"Sheldon" wrote in message
...
How do I prevent or disable in code a worksheet close, not a workbook
close?

Thanks