View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Sheldon Sheldon is offline
external usenet poster
 
Posts: 51
Default Closing a worksheet

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