How do I disable worksheet close method

[Jenny]

Hello.

All I need to know is how to disable a user's ability to
close a worksheet using the close button in the upper
right-hand corner of the worksheet window.

Any help is greatly appreciated.

~Jenny

 

[Frank Kabel]

Hi
you can't close a single worksheet. This 'X' will close the current
active window 8but not a single worksheet)

 

[Jenny]

Oh, I see what you are saying.

Let me rephrase the question <smile> If I have multiple
workbooks open, how can I programmatically prevent the
users from using the close button (or file option) to
close the workbook? I need that all to be done through my
code.

~Jenny

 

[Frank Kabel]

Hi
see Bob's answer to your other thread